Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
financialzone
New Contributor II

Multiple Arbitrary Date Ranges

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.

qlikview3datescreenshot.png

2 Solutions

Accepted Solutions
Partner
Partner

Re: Multiple Arbitrary Date Ranges

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/...

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.

Re: Multiple Arbitrary Date Ranges

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

7 Replies
Partner
Partner

Re: Multiple Arbitrary Date Ranges

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%20Sta...

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
Partner
Partner

Re: Multiple Arbitrary Date Ranges

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/...

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
financialzone
New Contributor II

Re: Multiple Arbitrary Date Ranges

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

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

Partner
Partner

Re: Multiple Arbitrary Date Ranges

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

image.png

 

#OnVacation #BetweenJobs.
Please ekskuse my Norglish and Swenglish typos.
financialzone
New Contributor II

Re: Multiple Arbitrary Date Ranges

Thank you this worked perfectly!

financialzone
New Contributor II

Re: Multiple Arbitrary Date Ranges

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