topic Re: different subcolumns in QlikView

different subcolumns

Sat, 02 Mar 2013 09:56:08 GMT

I am using Pivot table in QV 11

When we have to create sub columns in Pivot table, we create a dimension and drag it on top of the expressions. (see Actual sub columns.PNG)

But I want to create sub columns different in each column. (see Expected sub columns.PNG).

Please tell me if this is possible. If not what can be work around for the same.

Re: different subcolumns

alexandros17 — Sat, 02 Mar 2013 10:11:01 GMT

You can't do that, the only thing you can do out of a dimension is having columns for totals.

When you decide to evaluate expression under a dimension like in the first PNG all expressions are repeated under the dimension.

Re: different subcolumns

Sat, 02 Mar 2013 10:15:51 GMT

This is possible, at least, in two ways:

If your data only have values for the combinations you want to show, this will be automatic. I mean, your data model has values for [Column A] and [Sub col 1] but not for [Column A] and [Sub col 4].
Using IF() conditions in your expressions, having values only for the correct combinations. I think this is not a good solution, because of maintenance.

Juan Gerardo

Re: different subcolumns

alexandros17 — Sat, 02 Mar 2013 11:10:07 GMT

I disagree because each expression falls under the dimension used as header in a pivot so even if there aren't conditions for data the column will appear.

Re: different subcolumns

Sat, 02 Mar 2013 18:42:08 GMT

Look at this example, here you are the two ways in two pivot tables.

Hope this helps

Re: different subcolumns

Tue, 05 Mar 2013 07:04:24 GMT

Hello Juan,

I tried with the solution 1 you provided and it worked sucessfully.

Thank you very much.

But the only concern now I have is that the 1st dimenion shows the expansion icon.

Is it possible to suppress it?

Re: different subcolumns

Tue, 05 Mar 2013 10:25:15 GMT

Yes it is, you have to go to Chart Properties -> Presentation tab -> Check "Always Fully Expanded". This way the table will be always expanded to the last level, and the plus signs will dissapear.

Juan Gerardo.

Re: different subcolumns

Tue, 05 Mar 2013 10:41:35 GMT

But I have Other dimensions also which are not pivoted, where I need to show the expansion icons, to allow user to expand and collapse.