Qlik_077: How to convert non-optimized QVD load to optimized QVD load by simple technique.
In this video, we will see techniques to convert non-optimized QVD load to optimized QVD load.
00:00:01 Introduction
00:01:40 Technique to load only few years data from a QVD using Year field
00:04:35 Technique to load only few years data from a QVD using Date field.
If you want to read few blogs on this topic.
Bitmetric
https://www.bitmetric.nl/blog/qlik-op...
Qlik-Community
https://community.qlik.com/t5/QlikVie...
https://community.qlik.com/t5/QlikVie...
Quick Intelligence
https://www.quickintelligence.co.uk/q...
QlikView Essentials by Chandraish Sinha
https://www.oreilly.com/library/view/....
Ralf Becher GitHub
https://gist.github.com/ralfbecher/79...
Quick Code Pedro Pamplona
/ qlik-optimized-load-with-where-clause-and-...
You can also find me on
YouTube: / @manishkumarkachhia1683
Facebook: https://www.facebook.com/profile.php?...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: https://www.udemy.com/user/manish-kac...
Website: https://qliksolutions.com/
#qlik #qliksense #qlikview #qs #qv #qlikdatamodel #qlikscript #set #let #setvariable #letvariable #variable #newtoqlik #newtoqliksense #newtoqs #newtoqlikview #newtoqv #learnqlik #beginnerqlik #trace #tracestatement #debug #Trace #tablefunctions #qlikfunctions #qlik #fieldname #fieldnumber #nooffields #noofrows #nooftables #qvd #storeqvd #createqvd #addyears #addmonths #date #time #dateandtimefunctions #monthstart #monthend #yearstart #yearend #pick #match #customisedreport #pivottable #networkdays #Genericload #fieldvaluecount #fieldvalue #tablename #loop #forloop #variableswithparameter #aggr #firstsortedvalue #Textbetween #QlikExtension #Extension #QVDMetaData #Dimensionality #EnvironmentalVariables #FirstWeekDay #BrokenWeeks #ReferenceDay #optimized #non-optimized