Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Bharathi09
Creator II
Creator II

Filtering data In QV

Hello All, 
I have two variables in my Include file

LET vNumOfYears = 4;
LET vStartDate = date(Yearstart(AddYears(Today(),-$(vNumOfYears))),'YYYY-MM-DD');

Currently I am taking last 4 years of data, but now I just want to show Current Quarter+ last 4 Quarters of data
I want to remove taht 4 in NumOfYears and add my new condition there (4 quarters before + current quarter )

I need to show that in above variables

Please help to get this

thanks!!


1 Reply
BrunPierre
Partner - Master II
Partner - Master II

Maybe

LET vStartDate = Date(QuarterStart(AddMonths(Today(), -3 * $(vNumOfYears))), 'YYYY-MM-DD');