Discussion board where members can learn more about Qlik Sense App Development and Usage.
Struggling with an issue which i thought would be rather simple.
I would need to do an bring up some data from SQL based on dates and the difference btwn them should be exactly 10 years.
Ex: If any user opens the app today they should be able to see date ranging from 2/18/2006 to 2/18/2016.
Use Addyears function.
May be set a variable like this:
LOAD Date(AddYears(Max(Date), 10), 'DD-MMM-YYYY') as MaxDate,
Date(Max(Date), 'DD-MMM-YYYY') as MinDate
LET vMaxDate = Peek('MaxDate);
LET vMinDate = Peel('MinDate');
DROP Table MaxDate;
Where DateField >= $(vMinDate) and DateField <= $(vMaxDate);