topic Re: Pivot Table Expression column in QlikView

Pivot Table Expression column

sohb2015 — Tue, 24 Nov 2015 15:49:09 GMT

Hello All,

As we know, in a pivot table expression always come after the dimensions. Now i have requirement where I need to show the expression before few of the dimension.

For Ex.

Year Country Sale Status

2015 Australia 1000 A

2015 India 2000 A

Sale column is a expression: sum(sales).

Is it possible to design the pivot table like this?

Please help

Thanks

Re: Pivot Table Expression column

effinty2112 — Tue, 24 Nov 2015 16:22:13 GMT

Hi Sohini,

A straight table would be a better choice for you. You can drag the expression column along to the left but you can't have a horizontal dimension like you can in a pivot table.

Cheers

Re: Pivot Table Expression column

rubenmarin — Tue, 24 Nov 2015 16:26:36 GMT

Hi, one option is load dimensions after the expression as an expression instead of dimension.

Other option is the reverse: load the expression as a calculated dimension:

=Aggr(Sum(Sale), Year, Country)

Not tested.