Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Convert Columns to Rows in Pivot Table

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

5 Replies
sunny_talwar

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

el_aprendiz111
Specialist
Specialist

Hi

Expression:

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

Anonymous
Not applicable
Author

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.Screen1.JPG

sunny_talwar

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

Anonymous
Not applicable
Author

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.

Screen_Shot1.JPGScreen_Shot2.JPG