Qlik Community

Ask a Question

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
asantos
Contributor III
Contributor III

Columns to Rows for P&L Pivot

Hello!

My question has been asked, but the solutions don't answer all of my questions, given the situation here.

The dataset is as follows:

Dataset.PNG

This is how the P&L Pivot should look like:

IntendedDataset.PNG

Basically, the column headers would be now row headers, some of which will have to be calculated measures.

Could you point me to the right direction?

Thank you!

 

 

1 Reply
chrismarlow
Specialist II
Specialist II

Hi,

If you don't have the option of scripting to change you data model an option that may start to get you close to the output you want is using ValueList in a calculated dimension & then Pick/Match in expression, similar to the attached.

Cheers,

Chris.