Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set Multiple Months by Default

I'd like to set my document so that it selects the previous 2 full months based upon todays date. I can set one month by using variables and the Open trigger. But how would I select multiple months by default?

7 Replies
Not applicable
Author

Separate the expression for the two months with | in the the search string text box which should allow for two selections.

action.PNG.png

maxgro
MVP
MVP

all these works in my qlikview doc

='("Jul"|"Aug")'

another one

='(gen|feb)'

or

(gen|feb)

Not applicable
Author

What if I have variable in my search string?

=vPrevMonth|=v2PrevMonth

Like this:

Not applicable
Author

What if I have variables in my search string?

Not applicable
Author

You may need to do something like this (depending on how you defined your variables):

='(' & $(v2PrevMonth) & '|' & $(vPrevMonth) & ')'

Not applicable
Author

Can a bookmark be used in this case?

maxgro
MVP
MVP

I tried this in a button and it works

='($(vM1)|$(vM2))'

1.png