topic Re: Retrieving the last 10 days in QlikView

Retrieving the last 10 days

Anonymous — Wed, 03 Oct 2018 07:31:59 GMT

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 — Wed, 03 Oct 2018 15:14:58 GMT

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 — Thu, 04 Oct 2018 08:25:39 GMT

This is correct, thank you!