topic Re: Pivot Table in QlikView

Pivot Table

manojkulkarni — Fri, 15 Jul 2016 09:59:28 GMT

Hi Friends,

Below is the sample data which i need to convert to pivot in expected format. Have attached both the details. How can we achieve this ?

Any help will be appreciated.

Input Data:

Expected result

sunny_talwar — Fri, 15 Jul 2016 10:22:01 GMT

How are the totals getting calculated?

sunny_talwar — Fri, 15 Jul 2016 10:24:00 GMT

It seems that Totals are the avg for the region... Something like this?

Expression used:

=If(Dimensionality() = 2, Sum(Value), Avg(Value))

marcus_sommer — Fri, 15 Jul 2016 10:26:34 GMT

It looked that your totals are the average, right? Then you could use:

avg(Value)

or if you need to sum the value on the city-level with an aggr-function, like:

avg(aggr(sum(Value), City))

- Marcus

manojkulkarni — Fri, 15 Jul 2016 10:59:35 GMT

Thanks Marcus