Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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.

View solution in original post

3 Replies
sunny_talwar

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

Not applicable
Author

I created a qvf with the records.

sunny_talwar

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.