Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
omyahamburg
Creator II
Creator II

limit data in table by variable

Dear all

I am struggling.

I have a table as follows:

overdue amount.png

To calculate the days overdue I use the expression today()-[Due Date].

Now I want use a variable, e.g. vDay=500 and I like to limit the data in the table

only to show me those rows, where today()-[Due Date] <= 500 is.

I appreciate your help.

Joerg

12 Replies
omyahamburg
Creator II
Creator II
Author

Dear Itsangad

Seems perfect. I'll check in my final app if it works.

Thanks a lot.

Joerg

Not applicable

Sure, no problem. I just missed to remove the sum(Amount) column and also the rename of labels.

Let me know if in any other way I can help.

Thanks,

itsangad

omyahamburg
Creator II
Creator II
Author

Dear Itsangad

Don't worry, everything is fine so far. As I'm already at home without access to my server I'll check further with my app on Monday.

If I have problems I appreciate If I could count on further help from you.

enjoy your weekend.

Joerg