Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
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).
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post

3 Replies
Highlighted
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())
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
Highlighted
Creator
Creator

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

Highlighted
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).
Plees ekskuse my Swenglish and or Norweglish spelling misstakes

View solution in original post