Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sr_qlikview
Creator
Creator

Dimension limit total along with expression total

Is there a possibility to get dimension limit total on a staright table ?

ex: if i have selected dimension limits > show only >  lagest 10

i want to see total for top 10 and also expression total ... is this a possible scenario ?

8 Replies
Not applicable

Hi sr_qlikview! Did you get your problem solved? I have the same issue and couldn't find an answer yet... Tks a lot!

sr_qlikview
Creator
Creator
Author

Unfortunatley no ... i had to convince my user

Not applicable

So did I. Thanks anyway.

Not applicable

it is possible to get to both totals but the question really is where/how do you want to display them?

there's only room for one number.....

Not applicable

In my case, that's the problem. The user needs to see the subtotal and the total. The subtotal would show the top 10 values and the total, the complete expression...

sr_qlikview
Creator
Creator
Author

ok ... what if i only want the dimension limit total .. how to achieve that.

Not applicable

see attached which has the various options you are looking for

sr_qlikview
Creator
Creator
Author

Thankyou for your time, i did the same when user wanted to control the top list in a pivot table. but this is different from the issue listed here. i prefer not to go with calculated dimensions as they are not cached in memory.