Qlik Sense - Load set number of years using variables in Qlik Sense

[@thinkmetrics]

🎓 Get the Qliksense masterclass : www.thinkmetrics.se/masterclass 📕 Get the Formula CheatSheet: www.thinkmetrics.se/cheatsheet

[@sunithaathmuri4552]

Cool ..been searching for this concept..fortunately landed here ..Thanks alot Kaush

[@thinkmetrics]

You're welcome😊

[@inzamampowerbi4795]

This is great, been following your Videos. Please keep all your content fresh and based on real-time experiences

[@thinkmetrics]

Thanks

[@loke3969]

Thanks a lot. And interested see more .

[@thinkmetrics]

Great! 😊

[@Purna_naidu]

Great presentation cheers 🙂 kaush. And is there any particular reason using # before variable.i think it will work same Even without # in the variable.

[@Purna_naidu]

Waiting for your video.

[@apb1441]

Hey thanks for this, just curious how I could use the max date in the data(fact) rather then todays date to set the base date?

[@shashankhegde6844]

Cool stuff man! Just wanted to know how should we handle this if the fiscal year is different from the calendar year

[@thinkmetrics]

It depends. You should have a different calendar for fiscal or fields in the main calendar calling out the fyear, fmonths etc. But for loading the date, as in this video, set vl.NumberofYearsTOLoad = 6; let vl.basedate = today(); let vl.startfiscalyear = Year($(#vl.basedate)) +($(#vl.NumberofYearsTOLoad)*-1); let vl.startficalyeardate = Date('1/04/$(#vl.startfiscalyear)') Maybe this works?

[@shashankhegde6844]

@@thinkmetrics Yes, I set it in the main & used the expression! It works,Thanks💪 😊

[@loke3969]

Pretty nice

[@thinkmetrics]

Thanks 😊👍🏻

[@sarmapiratla2459]

May I please know why you used # in dollar expansion

[@evelivingx5047]

how can i set the 3 as a user input variable instead of hardcoding it in the loadscript?

[@thinkmetrics]

Hi. I would use an Excel file as an input n set that value to the number of years to load variable

[@Purna_naidu]

Hello kaush