topic Re: Hiding the dimension in Straight Table in QlikView

Hiding the dimension in Straight Table

Wed, 01 Apr 2015 14:58:09 GMT

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 -

and the required output should look like -

Total

2960

Thanks in advance.

Let me know in case any details required.

Regards,

sunny_talwar — Wed, 01 Apr 2015 15:09:15 GMT

Are you just looking for the Total?

Best,

Sunny

Wed, 01 Apr 2015 15:11:10 GMT

Hi,

Yes however for top 5 by amount

Regards,

Ajit

sunny_talwar — Wed, 01 Apr 2015 15:13:07 GMT

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

Wed, 01 Apr 2015 15:20:35 GMT

Thanks a ton.

Regards,

sunny_talwar — Wed, 01 Apr 2015 15:21:29 GMT

No Problem

Best,

Sunny