Solved: Pivot Table (-) problem - Qlik Community

Report Inappropriate Content · ‎2014-02-12

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

vikasmahajan · ‎2014-02-12

I think you should do this

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

Please share your dummy application.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

View solution in original post

vikasmahajan · ‎2014-02-12

I think you should do this

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

Please share your dummy application.

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2014-02-12

thank you for the quick response!

vikasmahajan · ‎2014-02-12

WelCome

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.