topic Re: Pivot table - Hide/show columns in QlikView

Pivot table - Hide/show columns

Thu, 29 Nov 2012 12:14:14 GMT

Hello all

I am trying to figure out how to solve the following.

1. Salesperson sells an item that belongs to a group and a subgroup.

2. The result is to be shown in a pivot table and the totals for items should only be showed for specific group and subgroup.

Note, them item is calculated from various information on the fly in the pivot table.

I have tried to use the Conditional property but I have not been able to get it to work. My value there needs to be calculated somehow and I haven't been able to figure out the right way. In the real data there are about 10 calculated values and multiple groups/subgroups.

Any help would be much apreciated.

Re: Pivot table - Hide/show columns

Gysbert_Wassenaar — Thu, 29 Nov 2012 12:26:02 GMT

Unfortunately that's not possibe with a pivot table. Any expression you add to a pivot results in a column for every value of the dimensions used for columns (like your Group and Subgroup).

Re: Pivot table - Hide/show columns

vgutkovsky — Thu, 29 Nov 2012 12:55:25 GMT

Well...normally Gysbert would be correct, but it seems from the Excel example you posted that you have only 1 expression? So you in fact want to conditionally show dimensions, not expressions, which is possible--that's exactly how QV's associative logic works by default. By the way, let's not use the language "conditionally show" since in QlikView that means that a dimension/expression itself is shown/not-shown in all cases.

I'd like to post an example, but first can you clarify what you mean when you say that the item is calculated on the fly?

Regards,

Vlad

Re: Pivot table - Hide/show columns

Thu, 29 Nov 2012 13:05:46 GMT

Thank you for the answers.

I have about 10 expressions and the items I am referring to are the expressions. So I only want to show a certain expression for a certain group and subgroup.

regards

einar

Re: Pivot table - Hide/show columns

vgutkovsky — Thu, 29 Nov 2012 13:41:39 GMT

Please post a reduced example.

Re: Pivot table - Hide/show columns

Fri, 30 Nov 2012 08:24:22 GMT

Please find an exampla attached.

Lets say that here

Item 1 and Item 2 should only be visible for A-X and A-Y

Item 3 only visible for B-V and B-Z

regards

einar

Re: Pivot table - Hide/show columns

vgutkovsky — Fri, 30 Nov 2012 17:08:29 GMT

Nothing was attached...

Re: Pivot table - Hide/show columns

Fri, 30 Nov 2012 17:24:13 GMT

Sorry, I attached it to my original post.

Re: Pivot table - Hide/show columns

vgutkovsky — Fri, 30 Nov 2012 20:30:35 GMT

See attached for a simple example of how this can be done.

Regards,

Vlad

Re: Pivot table - Hide/show columns

MayilVahanan — Fri, 30 Nov 2012 20:46:48 GMT

PFA

Slight change in Mr.Vlad Gutkovsky , to satisfy your requirement

Re: Pivot table - Hide/show columns

vgutkovsky — Fri, 30 Nov 2012 21:12:00 GMT

Mayil,

I assumed from his data model that there would be an automatic relationship between Group and Undergroup such that you only need to check Undergroup to get an implicit check on Group.

Vlad

Re: Pivot table - Hide/show columns

MayilVahanan — Fri, 30 Nov 2012 21:18:54 GMT

HI Mr.Vlad,

He mentioned that

Item 1 and Item 2 should only be visible for A-X and A-Y

Item 3 only visible for B-V and B-Z

I noticed that, in your demo, Group B doesn't contain Item3, i.e Data1+Data2+Data3

So only i changed slighlty, may be i misunderstood the concept.

Regards,

R.Mayil Vahanan

Re: Pivot table - Hide/show columns

vgutkovsky — Fri, 30 Nov 2012 23:25:36 GMT

Ah, you're right, I didn't notice that, thanks.

Re: Pivot table - Hide/show columns

Sat, 01 Dec 2012 07:25:15 GMT

Perfect! Thank you.

Re: Pivot table - Hide/show columns

vgutkovsky — Sat, 01 Dec 2012 14:36:33 GMT

Please verify *all* correct/helpful answers, thanks.