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
www.bitmetric....
Qlik-Community
community.qlik...
community.qlik...
Quick Intelligence
www.quickintel...
QlikView Essentials by Chandraish Sinha
www.oreilly.co....
Ralf Becher GitHub
gist.github.co...
Quick Code Pedro Pamplona
/ qlik-optimized-load-wi...
You can also find me on
TH-cam: / @manishkumarkachhia1683
Facebook: www.facebook.c...
LinkedIn: / manishkachhia
Twitter: / mk_qsl
Udemy: www.udemy.com/...
Website: qliksolutions....
#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

[@vinodbolla3293]

Hi sir,
Really your videos are very supportive for us..

[@farinsaifutdinov5534]

Hello Dear Manish!
Your videos are very helpful and educational! Please keep up the good work

[@shekharanalytics9337]

Dear Manish , Your vedios are short and to the point .
Please also make a vedio on iter(),Peek and loops in qlik

[@pumapumi7293]

Excellent!

[@haleshab3216]

Hi Manish,
I have got a similar requirement today.
But in my case I need to generate a timestamp from
01/Apr/2023 00:00:00 to the current day timestamp(17/Oct/2023 23:59:59).
Note: Currently I have done that using cross join between generated dates and generated timestamp.
But do you have any idea on how we can do it in a more optimized way?