Dual Date Range

annjiang — Wed, 07 Aug 2019 14:51:53 GMT

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.

Re: Dual Date Range

Brett_Bleess — Mon, 26 Aug 2019 19:38:08 GMT

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/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

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

Regards,
Brett

topic Re: Dual Date Range in QlikView

Dual Date Range

Re: Dual Date Range