topic Re: Pivot Table Aggregation in QlikView

Pivot Table Aggregation

manish_kumar — Tue, 17 Jul 2018 08:50:35 GMT

I have a data along two dimensions having date (Date1, Date2) (attached data).

I need the data in the first column whenever the data flow in Date2.

Please refer the attachement.

Re: Pivot Table Aggregation

petter — Tue, 17 Jul 2018 13:54:09 GMT

It is possible to get a solution like you hope for:

Had to let the associative model help me to shift the columns to the left by using this helper table... I know ... it could have been done programmatically but I just hacked this together - so feel free to code a more elegant solution.

Re: Pivot Table Aggregation

manish_kumar — Thu, 19 Jul 2018 12:23:47 GMT

HI Petter

Thanks for the solution.

But I am stuck in making the columns dynamic. Is there any way out to make the combinations Dynamic because rows and columns will increase on regular basis and it will be very difficult to define the combinations every time in inline table.

Re: Pivot Table Aggregation

petter — Thu, 19 Jul 2018 13:53:38 GMT

You mean the QY table?

Re: Pivot Table Aggregation

manish_kumar — Thu, 19 Jul 2018 13:58:56 GMT

Yes QY table..

Re: Pivot Table Aggregation

petter — Thu, 19 Jul 2018 16:20:31 GMT