topic Re: Do not require grouping in Pivot table in QlikView

Do not require grouping in Pivot table

agni_gold — Wed, 23 Aug 2017 09:22:53 GMT

Hi Friends,

I have a situation, I have one pivot table with multiple dimensions and 1 expression, and I have also done pivoting in that table, but the requirement is,

we want to pivot but not a grouping of dimensions values they should repeat like a straight table.

Re: Do not require grouping in Pivot table

vinieme12 — Wed, 23 Aug 2017 09:40:33 GMT

You just need to add the prevailing dimension to the next one

for example

Dim1

Dim2 & chr(10) & Dim1

Dim3 & chr(10) & Dim2

Dim4 & chr(10) & Dim3

and so on....

Re: Do not require grouping in Pivot table

agni_gold — Wed, 23 Aug 2017 09:42:38 GMT

it will look like straight table ?

Re: Do not require grouping in Pivot table

vinieme12 — Wed, 23 Aug 2017 09:44:29 GMT

post a sample

Re: Do not require grouping in Pivot table

vinieme12 — Wed, 23 Aug 2017 09:47:25 GMT

correction it has to be the other way round

You just need to add the prevailing dimension to the next one

for example

Dim1 & Chr(10) & Dim2

Dim2 & chr(10) & Dim3

Dim3 & chr(10) & Dim4

Dim4 & Chr(10) & Dim5

Dim5

and so on....

Re: Do not require grouping in Pivot table

agni_gold — Wed, 23 Aug 2017 09:55:38 GMT

First Column values should repeat.

Re: Do not require grouping in Pivot table

tresB — Wed, 23 Aug 2017 10:06:49 GMT

Try creating a Key field in the script like:

Autonumber(Country&State) as Key

and then a calculated dimension :

=Dual(Country, Key)

Re: Do not require grouping in Pivot table

agni_gold — Wed, 23 Aug 2017 10:15:11 GMT

and if i have more than 2 dimensions in table then i need to create individual keys for each dimensions ?

Re: Do not require grouping in Pivot table

vinieme12 — Wed, 23 Aug 2017 10:19:34 GMT

No just create create a composite key with all possible fields that you will be using in the dimension

Autonumbrr (Dim1 &...........)

Re: Do not require grouping in Pivot table

tresB — Wed, 23 Aug 2017 10:21:40 GMT

You have to create/find a numeric key for all dimensions that you want ungroup in the chart. And you have to careful about using this key combination since they composite key order would decide your aggregation as well.