Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

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