topic Re: Toggle between 2 Categories in QlikView

Toggle between 2 Categories

Anonymous — Wed, 25 Feb 2015 13:26:44 GMT

I have 6 dimensions, which can be split into two categories.

Category A: Company_A_Location1, Company_A_Location2, Company_A_Location3

Category B. Company_B_Location1, Company_B_Location2, Company_B_Location3

I want to be able to select either A or B, by creating a variable or through some other means, and have the corresponding Category dimensions showing in the listboxes and tables on the sheet.

Re: Toggle between 2 Categories

sunny_talwar — Wed, 25 Feb 2015 13:50:19 GMT

Would you be able to provide a sample application or Excel file to look at the exact structure of your data?

Best,

Re: Toggle between 2 Categories

avinashelite — Wed, 25 Feb 2015 13:55:53 GMT

try to split the columns in the script and create a inline field for the category toggle.

If your facing any issue please provide the sample data.

Re: Toggle between 2 Categories

Anonymous — Wed, 25 Feb 2015 13:57:28 GMT

You could create a couple of bookmarks for your 2 selection states.

Or have Triggers on Button or Text objects that do selections when they are clicked.

Re: Toggle between 2 Categories

linusblomberg — Wed, 25 Feb 2015 14:02:12 GMT

Sure, you can do this in so many ways with variables.

Start with a button to change the variable vCompanyCategory

You can do a calculated dimension where you'd say, if(vCompanyCategory='A', Company_A_Location1,Company_B_Location1)

or you could do 3 dim variables

vCompanyLocation1

vCompanyLocation2

vCompanyLocation3

defined in the same way: if(vCompanyCategory='A', Company_A_Location1,Company_B_Location1)

What I think is the nicest way though is if you don't do it using variables but work on your data model and create a field with CompanyCategory.

hope this helps

Re: Toggle between 2 Categories

Wed, 25 Feb 2015 14:35:50 GMT

Hi Christopher:

It's a bit cumbersome, but maybe you can use it as a template for what you need.

https://www.dropbox.com/s/sz1m2c2patoyg4u/test.qvw?dl=0

Hope it helps.

Re: Toggle between 2 Categories

Wed, 25 Feb 2015 14:50:18 GMT

Also you can create all 6 listboxes and use Show Conditional from Layout page, with conditions vCompanyCategory='A' or vCompanyCategory='B'.