Qlik Community

Qlik Sense App Development

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

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
MVP
MVP

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
MVP
MVP

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.

MVP
MVP

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.