Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
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
Partner - Master

Maybe

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