topic Re: Alternate State PIVOT tables in QlikView

Alternate State PIVOT tables

Wed, 25 Nov 2020 16:16:04 GMT

Hi amazing community.

I have a question which seems to be fairly simple, but I can get it to work.

I have 1 listbox, and 1 Pivot table. This Pivot table has 1 simple dimension (not calculated) this dimension is called "employee" and contains 6 names. Furthermore the Pivot table contains 10 calculated expressions. When I make a selection of an employee name in my listbox, the Pivot table will adjust and only show the column with the selected name.

Now I would like to duplicate my listbox and Pivot table, so I can do a comparison. I gave my listbox and alternate state (stateA) and applied the same alternate state to my Pivot table. But now when I make a selection in my listbox, the Pivot table doesn't change anymore and will still show all 6 columns with all 6 names of the dimension.

I was wondering if it is possible to use alternate state and have only the column displayed which I'm interested in based on my selection in the listbox?

Thank you very much for your help!

Re: Alternate State PIVOT tables

pooja_sn — Fri, 06 May 2016 15:39:23 GMT

ListBox selections will reflect on Pivot table if both the sheet object have the same Alternate State.

Please share your qvw if possible.

Re: Alternate State PIVOT tables

oscar_ortiz — Fri, 06 May 2016 17:54:59 GMT

It sounds like you want to create a second list box using the same alternate state as the pivot table.

Re: Alternate State PIVOT tables

marcus_sommer — Sat, 07 May 2016 11:12:23 GMT

Your approach sounds ok. Commonly will be two states (group A + group B) created for such a direct comparisation but it should also work if only one listbox/pivot is assigned to a named state and the other to the default state of the document. Therefore have a check if you have really assigned the states to the right objects and also have a look on the expressions which you used - then if you used set analysis expressions you could overwrite the state-assignment, for example an expression like: sum({$ < Field = {'Anyvalue'}>} Value) will ignore the state then it is per $-sign assigned to the document default-state.

- Marcus

Re: Alternate State PIVOT tables

Mon, 09 May 2016 08:54:32 GMT

Thank you very much Marcus,

The $-sign was indeed the character in the expression that made the Pivot table not respond the way I was looking for. Removing the $ sign solved the problem!

Thank you all for your help, very much appreciated!!