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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Create toggle between date selection of by month or by quarter

Good Morning;

       I have recently been tasked with adding a quarter view to a financial application set.

Currently it is shown by month, I have read that to create a toggle i need to do =if(vToggle=0,1,0)  However in this case what is the vToggle as the two date items are _MON for month and_Q for quarter.  Im a little confused as how to create a proper variable to capture both.  I attached a screen shot of the values.

Thank you in advance

Labels (1)
1 Solution

Accepted Solutions
Vegar
MVP
MVP

Make sure that the variable exists.

You can also try to type
=if('$(vToggle)'=0,1,0).

View solution in original post

3 Replies
Vegar
MVP
MVP

Keep your vToggle variable toggle and add both quarter and month as dimensions into your chart/table. In the dimension properties check the conditional show for both dimensions and adjust the show conditions as below.

For the quarter dimension your type
=if($(vToggle)=1, true(), false())

For the month dimension conditional show you type
=if($(vToggle)=0, true(), false())
Anonymous
Not applicable
Author

Thank you for the Reply Vegar;

          i sent to the variable section and it wont save because of an error when putting in =if(vToggle,0,1,0).
Is there something i need to add in?  I am new to using variables. I added another screen shot.

Thank you in advance

Vegar
MVP
MVP

Make sure that the variable exists.

You can also try to type
=if('$(vToggle)'=0,1,0).