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]

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!

Qlik Sense Business  Qlik Sense Enterprise on Windows  

[Vijiraja]

@sunny_talwar - please look into this

Thanks in Advance!