Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
oscarmqz
Creator III
Creator III

Totals for all columns in pivot table

Hi, I have this pivot table where the second column are my expressions.

How can I get a Big Total so it looks like this, instead of partial sums by dimension

Thanks in advance!

1 Solution

Accepted Solutions
uacg0009
Partner
Partner

Hi Oscar,

If user don't need to filter the first and second dimension, I think you can use valuelist() to do the dimension, like

valuelist('US','CA','Total').

And also change the expression.

But if you have filter about the dimension, I think I need to find another to solve it.

Aiolos

View solution in original post

6 Replies
jayanttibhe
Creator III
Creator III

Hi

can you please share the sample app with data ?  It will be lot easier of you calculate the fact data based on 2 OR many countries in the data model itself.

vishsaggi
Champion III
Champion III

In Presentation tab - Select your 2nd dimension - Then check show partial sums option - then give Label as Thin Clients in Labe for Totals text box. Like below:

Capture.PNG

uacg0009
Partner
Partner

Hi Oscar,

If user don't need to filter the first and second dimension, I think you can use valuelist() to do the dimension, like

valuelist('US','CA','Total').

And also change the expression.

But if you have filter about the dimension, I think I need to find another to solve it.

Aiolos

View solution in original post

oscarmqz
Creator III
Creator III
Author

Hi Aiolos, thanks for your answer, the user won't be filtering the dimensions, what my expression should look like? I guess I need an IF or set analysis to filter based in the valuelist

oscarmqz
Creator III
Creator III
Author

I got it working, thanks Aiolos! the valuelist did the trick

uacg0009
Partner
Partner

You're welcome, glad to help you~