Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
juveluis
Contributor
Contributor

Retrieving the last 10 days

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.

1 Solution

Accepted Solutions
deec
Creator
Creator

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.

View solution in original post

2 Replies
deec
Creator
Creator

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.

juveluis
Contributor
Contributor
Author

This is correct, thank you!