I'm new at qlik and i'm facing a problem that i can't resolve.
Considering i have a table:
Date & ' - Day format ' as Daily1
With this table, i want to retrieve the last 10 days from the Daily1 field.
Is it possible? Thanks for the help.
Do you want them in a separate table?
Date & ' - Day format ' as Daily1,
Daily1, 1 as Last10DayFlag,
RESIDENT Table1WHERE Date >= Today()-10;
DROP Field Date;
Now you can use the Last10DayFlag anywhere in your UI to easily select only the Daily1's for the last 10 days.
View solution in original post
This is correct, thank you!