Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
rlhardin
Contributor

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
Partner
Partner

Re: Create toggle between date selection of by month or by quarter

Make sure that the variable exists.

You can also try to type
=if('$(vToggle)'=0,1,0).
Please ekskuse my Norglish and Swenglish typos.
3 Replies
Partner
Partner

Re: Create toggle between date selection of by month or by quarter

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())
Please ekskuse my Norglish and Swenglish typos.
rlhardin
Contributor

Re: Create toggle between date selection of by month or by quarter

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

Partner
Partner

Re: Create toggle between date selection of by month or by quarter

Make sure that the variable exists.

You can also try to type
=if('$(vToggle)'=0,1,0).
Please ekskuse my Norglish and Swenglish typos.