topic Re: Transposing a field values as columns in QlikView

Transposing a field values as columns

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I have my data set as the below. Importing this table from SQL database.

I want to transpose the KPI field to columns like the below.

I tried generic load and concatenating, but its taking so much time to load the script and gets struck after a point of time. Are there any better ways to do it ?

Thanks for your help !

Re: Transposing a field values as columns

giakoum — Tue, 01 Nov 2016 15:47:21 GMT

crosstable function

Re: Transposing a field values as columns

vishsaggi — Tue, 01 Nov 2016 15:51:30 GMT

Load the data and use Pivot table.

Add Dim: Month and KPI

Add Expr: Sum(Value)

Then transform KPI by dragging on top of the expression value.