This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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!
If user don't need to filter the first and second dimension, I think you can use valuelist() to do the dimension, like
And also change the expression.
But if you have filter about the dimension, I think I need to find another to solve it.
View solution in original post
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.
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:
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
I got it working, thanks Aiolos! the valuelist did the trick
You're welcome, glad to help you~