topic Re: Conditionally hiding pivot table total values in QlikView

Conditionally hiding pivot table total values

Wed, 24 Sep 2014 05:15:31 GMT

Hi,

Please take a look at the attached sample file. Here, when user selects 'hide' in the list box, I would like to display a '*' for all quantity expressions. The thing I can't figure out is how to hide a row's total if any of the values of the expression for that row is less than 10. In this example, the second row for toyota hides the blue quantity (since it's 8), but it shows the total value of 18. Obviously, user can deduct the blue quantity by subtracting this total from the red color quantity. How could I hide the total for this row and only show the 10 quantity for blue color.

Re: Conditionally hiding pivot table total values

perumal_41 — Wed, 24 Sep 2014 05:39:48 GMT

PFA application.i thing solve your problem.

Regards,

Perumal A

Re: Conditionally hiding pivot table total values

Wed, 24 Sep 2014 06:18:19 GMT

Hi,

Thanks for your reply. I see that this solution worked perfectly on my sample application. However, my production table is much more complicated than this example, and I also use ODBC connection to pull in data directly from the source. In order to implement this solution on my real table can you explain this syntax you sgguested:

sum({<key={"=sum(quantity)>=10"}>}quantity)

What exactly is happening here?

Re: Conditionally hiding pivot table total values

perumal_41 — Wed, 24 Sep 2014 06:22:47 GMT

Hi,

first create unique key based color and car.

sum(quantity)>=10 then unique key rleated value take for calculation ,otherwise not take.