Dual Date Range

[annjiang]

Hello,

I am using WeekRange as filter, and  the date displayed like this ''Jul 03-Jul 09 2019'', now I want when the report open or reload , it only shows the last 6 weeks data, Could you please help me how to do this? attached the the file and the screenshort.

 Also I put '("Jun 26-Jul 02 2019"|"Jul 03-Jul 09 2019")' in WeekRange Select In Field and it works when first open the report but it did not work when reload the data,  Can you please tell the reason?

Thank you.

[Brett_Bleess]

If you are using the Desktop Client in this case, when you run a reload of the data model, that is going to clear all your selections etc. once the reload completes I believe.  If this is only going to be used in the Desktop Client, you could use the OnPostReload trigger to reapply your selection in that case, which should do what you want I believe.  

If you are using Ajax Client on the server, then that will not work, as OnPostReload does not trigger server-side.  The only way I see otherwise would be using Set Analysis, including a few links for you on that:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

Quite a few other links at the bottom of the above link's post, just FYI.

Here is the Help associated with Set Analysis as well:

https://help.qlik.com/en-US/qlikview/November2018/Subsystems/Client/Content/QV_QlikView/ChartFunctio...

This will kick this back up with my post, so maybe someone else will have a better option for you too.

Regards,
Brett