topic Pivot Tables in QlikView

Pivot Tables

Mon, 14 Oct 2013 10:51:07 GMT

I have something like this in raw data:

That I want to display like this in a report table:

The first part of having the (Count Days Bucket) Columns is done. Now I need to repeat those columns on the right, for the Sum of Amount.

Also I want it done in a way that if I add new rows with new periods of days, it automatically add's a new column to the report table, like in Excel.

Message was edited by: Miguel Domingos 2013-10-14 at 14h11m GMT

bbi_mba_76 — Mon, 14 Oct 2013 12:51:34 GMT

Hi,

you have to add the show partials sums in the presentation tab

Mon, 14 Oct 2013 14:56:29 GMT

The partial sums shows totals, does not repeat the same columns to the right.

bbi_mba_76 — Mon, 14 Oct 2013 15:02:23 GMT

Sorry, but adding the second expression you have what you want.

rustyfishbones — Mon, 14 Oct 2013 15:11:19 GMT

Just click and drag until you get the format you want

here is a file with it done

Mon, 14 Oct 2013 16:39:11 GMT

Yes but I should drag the lines not the columns as I was doing.