Display current date in one filter and all previous date in another filter and create a table or pivot to compare the values between 2 date filters

Vijiraja — Tue, 14 Jun 2022 15:46:02 GMT

Dear Qlik Professionals,

Need some help or advise on building the app based on date fields.

Consider report date as "YYYYMMDD" in the format.

My app should display like below based on the selections in the filter

Filter 1 : Current Report date : YYYYMMDD(20220614)

Filter 2: should display all the values based on above selection less than YYYYMMDD(20220614) like (20220612,20220506,etc.,)

And in table chart or pivot chart , only display the measure values based on the above selections ie current date and previous date filters

current date(20220614) previous date(20220506)(* user selected from above filter2 dropdown)

category1 value1 value2

category2 value3 value4

Please respond this post at earliest.

Thanks and Regards!

Re: Display current date in one filter and all previous date in another filter and create a table or pivot to compare the values between 2 date filter

Vijiraja — Tue, 14 Jun 2022 15:53:22 GMT

@sunny_talwar - please look into this

Thanks in Advance!