Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Hiding the dimension in Straight Table

Dear All,

I am trying to the total of top 5 items out of 8 in straight table however want to hide the dimension. The example data  is -

 

ItemAmount
C800
D654
A500
B356
H350
G300
F200
E100

and the required output should look like -

 

Total
2960

Thanks in advance.

Let me know in case any details required.

Regards,

1 Solution

Accepted Solutions
sunny_talwar

Sum of top 5 is 2660. PFA if this is what you want

Expression used: =If(Dimensionality() = 0, Sum({<Amount = {'=Rank(Sum(Amount)) <= 5'}>}Amount))

and hide the Item dimension on the presentation tab

Best,

Sunny

View solution in original post

5 Replies
sunny_talwar

Are you just looking for the Total?

Best,

Sunny

Not applicable
Author

Hi,

Yes however for top 5 by amount

Regards,

Ajit

sunny_talwar

Sum of top 5 is 2660. PFA if this is what you want

Expression used: =If(Dimensionality() = 0, Sum({<Amount = {'=Rank(Sum(Amount)) <= 5'}>}Amount))

and hide the Item dimension on the presentation tab

Best,

Sunny

View solution in original post

Not applicable
Author

Thanks a ton.

Regards,

sunny_talwar

No Problem

Best,

Sunny