Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Announcing the newest addition to the Qlik Community, Qlik Gallery! Learn More
Highlighted
Not applicable

Pivot table with fixed coluns

Hello,

I needed build a table like this image

2016-08-08_1420.png

- Data is dynamic, depends  user selection

- Meta,Total,Diff is measures fixed

In Qliksense i don´t found one soluction for it.

1 Solution

Accepted Solutions

Re: Pivot table with fixed coluns

For some reason, I am unable to make the Diff column work due to unable to divide it with a Only(Meta). Other than that, everything is working

Capture.PNG

Please check if this is what you wanted. Attaching the qvf for your review.

3 Replies

Re: Pivot table with fixed coluns

Would you be able to post an Excel file with the raw data to get this solution?

Not applicable

Re: Pivot table with fixed coluns

I created a qvf with the records.

Re: Pivot table with fixed coluns

For some reason, I am unable to make the Diff column work due to unable to divide it with a Only(Meta). Other than that, everything is working

Capture.PNG

Please check if this is what you wanted. Attaching the qvf for your review.