Retrieving the last 10 days

[Anonymous]

Hello all,

I'm new at qlik and i'm facing a problem that i can't resolve.

Considering i have a table:

Table1:

LOAD

     Day,

     Date & '  - Day format ' as Daily1

RESIDENT Master_Calendar

With this table, i want to retrieve the last 10 days from the Daily1 field.

Is it possible? Thanks for the help.

[deec · Accepted solution]

Do you want them in a separate table?

Table1:

LOAD

     Day,

     Date & '  - Day format ' as Daily1,

     Date

RESIDENT Master_Calendar;

LastTenDaily1s:

LOAD

     Daily1,
     1 as Last10DayFlag,

     Date

RESIDENT Table1
WHERE 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.

[Anonymous]

This is correct, thank you!