Convert pivot table in straight table

[vkal12]

Hello Community,

I want to convert a pivot table into a straight table for the use in NPrinting. The reason is that I would like to do some specific formatting for columns on my table in NPrinting for which I need to create a straight table in Qlik Sense. 

As columns I want to display each day of the current month and as rows I need to have specific KPI's. Within my data model I have the following fields: 

ID,

Date,

Month,

Year,

Day

My table looks like this at the moment: 

If I create a pivot table using multiple KPI's it will look like this as I only have two days to display at the moment. The KPI's are just examples... 

I want to have exactly the same table just in a straigth format. I have the possibility to change the data within my data load editor. What would be the best way to do it? 

Thank you very much in advance.

Best regards,
Vanessa

[RafaelBarrios]

Hi @vkal12 

That would be as a reverse crosstable and for that I can only think in generic load

Take a look to this post

https://community.qlik.com/t5/QlikView-App-Dev/Row-values-as-fields-opposite-of-crosstable/m-p/27317...

hope this works for you

best,