Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Sebastian_Dec
Creator II
Creator II

Qlik sense pivot hide some totals column

Hello, I'm making a table in pivot and summing the values in shops.
I check "Schow totals" and have values such: area and its ok, but such values as: opening date or customer number/ID should not be added up to Totals.

Sebastian_Dec_0-1676967162044.png

How can I disable "Total" for a piece of data in pivot?
Can you please give a step by step answer?

Sebastian_Dec_1-1676967205800.png

 

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
Labels (2)
1 Solution

Accepted Solutions
Sebastian_Dec
Creator II
Creator II
Author

ANSWER: You cant make this in Qlik 😞

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

2 Replies
Sebastian_Dec
Creator II
Creator II
Author

I know I can make function in "Background color expression" and "Text color expression" like this:
=if('Opening date' >= Today(), White())

And total date 19.10.3560 now is white on the white background but while someone download this to xlsx the date is still there.

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.
Sebastian_Dec
Creator II
Creator II
Author

ANSWER: You cant make this in Qlik 😞

Thanks & Regards,
Please close the thread by marking correct answer & give likes if you like the post.