Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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

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

Thanks a ton.

Regards,

sunny_talwar

No Problem

Best,

Sunny