Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zahidrahim_ocp
Partner - Creator
Partner - Creator

Date Filter to impact data

Dear Experts,

I am making an aging report. Suppose i have 2 tables:

Buckets:

Days     Bucket

1                 0-30

2                 0-30

3                 0-30

4                 0-30

5                 0-30

31               31-60

32               31-60

33               31-60

61               31-60

62               31-60

63               31-60

Main_query

TRDate                    Stock_Qty

01-SEP-2017          10

02-SEP-2017          20

05-SEP-2017          30

10-SEP-2017          40

Load Script joins these two tables like below:

SYSDATE-TRDATE  = Days

to get the bucket wise quantity.

Now the issue is instead of a fixed SYSDATE i want to give a date filter on front end and the then buckets should be calculated as per the date selected and data change accordingly.

Regards,

Zahid Rahim

6 Replies
shraddha_g
Partner - Master III
Partner - Master III

create a variable as vDate.

declare it as vDate = Max(DateField)

then use it while creating buckets in Dimension section of chart.

For ex.

If(Date($(vDate))-Date(TRDATE) >0 and Date($(vDate))-Date(TRDATE) <30, '0-30 Days',

             If(Date($(vDate))-Date(TRDATE) >31 and Date($(vDate))-Date(TRDATE) <60, '31-60 Days'))

zahidrahim_ocp
Partner - Creator
Partner - Creator
Author

Dear Sharadha,

Using it as Dimension gave Invalid Dimension then i put it in measure and worked.

But the main problem is i want to show all buckets and data keep appearing in relevant buckets. rather than as a separate column.

Regards,

Zahid Rahim

shraddha_g
Partner - Master III
Partner - Master III

Share sample app

zahidrahim_ocp
Partner - Creator
Partner - Creator
Author

How can we attach a qvf file with the message i am sorry as i never attached before.

zahidrahim_ocp
Partner - Creator
Partner - Creator
Author

I have successfully attached qvf. now we have to replace today with the date selected in the filter.

zahidrahim_ocp
Partner - Creator
Partner - Creator
Author

Awaiting any help badly