topic Convert Columns to Rows in Pivot Table in QlikView

Convert Columns to Rows in Pivot Table

Anonymous — Mon, 26 Sep 2016 16:19:23 GMT

So, I have a number of columns (50-60 columns out of 170 columns) which are the dynamic and keep changing every time.

Now, I need to convert them into Rows and keep them under a specific Column which we will create.

Is this possible in QlikView?

TIA

Re: Convert Columns to Rows in Pivot Table

sunny_talwar — Mon, 26 Sep 2016 16:49:37 GMT

Would you be able to share a sample of data to see how it is coming? In general you should be able to The Crosstable Load

Re: Convert Columns to Rows in Pivot Table

el_aprendiz111 — Mon, 26 Sep 2016 16:51:36 GMT

Expression:

RangeSum(Column1,Column2,Column3,Column4......)

Re: Convert Columns to Rows in Pivot Table

Anonymous — Mon, 26 Sep 2016 17:16:12 GMT

hello Sunny,

I wish I could share the data but I'm not supposed to.. I am sharing a ScreeShot, the blacked out column headers are dynamic and keep changing for every report, and those are just a few and they are many... I want to create a new column and make these as the rows under that column.

Re: Convert Columns to Rows in Pivot Table

sunny_talwar — Tue, 27 Sep 2016 15:52:09 GMT

Abdul -

I think it would be good for you to read these thread

QlikCommunity Tip: How to get answers to your post?

Preparing examples for Upload - Reduction and Data Scrambling‌

All we ask for a dummy sample which somewhat close to your actual problem/issue and once we are able to resolve your issue in the sample, you will be able to carry it forward to your actual problem. Don't have to share your confidential data, but unless you share more, we will always have trouble helping you.

HTH

Best,

Sunny

Re: Convert Columns to Rows in Pivot Table

Anonymous — Tue, 27 Sep 2016 16:06:19 GMT

Hi,

So I have used Alteryx and converted the Column names as a row under a New Column name (Screen Shot 1), The Values under ConfigModel were all as column names in the excel and the values under AVBOM_QTY are values under each ConfigModel. Now the task is to show the values under ConfigModel as row values instead of them in one single column to make it Like-Like as in Excel. (Screen_Shot2).

But they should remain as values and not as Column Names because they are subjected to change as they are dynamic fields.