topic Pivot Table (-) problem in QlikView

Pivot Table (-) problem

Wed, 12 Feb 2014 09:59:15 GMT

Hi all,

I just made pivot table containing the following information:

Customer Revenue

I added a slider so that i can switch between top 5/10/etc to see how much revenue there has been made per customer.

However when i get a top 5/10/.. etc it also shows me a 6th space called -. In this field it just sums up all the revenue from the customers that are not shown in my top5/10/..

Is there a way to exclude this field or not show it?

kind regards

Re: Pivot Table (-) problem

vikasmahajan — Wed, 12 Feb 2014 10:18:21 GMT

I think you should do this

Select Dimension -> Tick -> Suppress when value is null

Please share your dummy application.

Vikas

Re: Pivot Table (-) problem

Wed, 12 Feb 2014 10:23:40 GMT

thank you for the quick response!

Re: Pivot Table (-) problem

vikasmahajan — Wed, 12 Feb 2014 10:25:15 GMT

WelCome