topic Re: Multiple Arbitrary Date Ranges in QlikView

Multiple Arbitrary Date Ranges

financialzone — Sat, 16 Nov 2024 20:57:33 GMT

Hello, I’m relatively new to Qlikview and have a question.

I need to have 3 different date filters that are arbitrary in nature, so they cannot be dependent upon one another. I simply want to be able to add any date ranges (up to 3) I desire to perform comparisons on Unit Sales. How should I approach creating these separate filters? Is this something that is handled only in the expression syntax or is it done using the master calendar + expression? I'm really not sure where to start with this one.

I posted this in a different forum about 2 weeks ago, but got no responses.

Thank you in advance.

Re: Multiple Arbitrary Date Ranges

Vegar — Tue, 30 Apr 2019 17:53:30 GMT

I think you should look into the concept of alternate states. By having three states you can choose freely any three date intervals as you like.
https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Alternate%20States.htm

Re: Multiple Arbitrary Date Ranges

Vegar — Tue, 30 Apr 2019 17:58:19 GMT

Another solution is to apply variables that you user in your expressions.

Create a min and max variable for each independent interval you want and use these to limit your date ranges in each expression.

If you are not familiar with set analysis then the help is a good place to start. https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/SetAnalysis/set-analysis-expressions.htm

Re: Multiple Arbitrary Date Ranges

financialzone — Wed, 01 May 2019 16:00:17 GMT

Thank you Vegar. Looking at Alternate States, it seems as though I would have to have a separate chart for each of the 3 states. If that's the case, then this would not work for me, as the comparison would need to be done in the same chart (table).

Your other suggestion of applying variables - would this work using the same chart (table)?

Thank you.

Re: Multiple Arbitrary Date Ranges

sunny_talwar — Wed, 01 May 2019 16:03:02 GMT

A single chart can have three expressions which are driven off of three different states

Re: Multiple Arbitrary Date Ranges

Vegar — Thu, 02 May 2019 09:33:44 GMT

See attached example how to use two states in a chart.

Re: Multiple Arbitrary Date Ranges

financialzone — Thu, 16 May 2019 17:08:20 GMT

Thank you this worked perfectly!

Re: Multiple Arbitrary Date Ranges

financialzone — Thu, 16 May 2019 17:09:00 GMT

Thank you this worked perfectly! Sorry it took so long to respond - I was on vacation.