Date Filter to impact data

[zahidrahim_ocp]

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

[shraddha_g]

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]

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]

Share sample app

[zahidrahim_ocp]

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

[zahidrahim_ocp]

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

[zahidrahim_ocp]

Awaiting any help badly