topic Re: How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot tabl in QlikView

How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot table?

dailyfood — Sat, 16 Nov 2024 19:07:37 GMT

Hi,

I have attached a sample QVW.

I have a pivot table with 3 dimensions, the measure is the count of complaints per 100 orders. I want to highlight the best month in each subcategory (the smallest number row-wise).

I was not able to make it highlight a cell if it is zero.

This is what I want to highlight

Re: How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot tabl

sunny_talwar — Wed, 12 Feb 2020 20:12:13 GMT

I think it is a problem related to missing data.... for the second row where Issue = 'Burned'... you will see that there is no data in the app for Aug 2020... because there is no data... available... it isn't able to return 0 as the Min... if you can create a row with 0 as value... it should work.

Re: How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot tabl

dailyfood — Wed, 12 Feb 2020 20:29:42 GMT

Unlike SUM() where you could add dummy records with "0" and it won't change the end result. I don't think I can do this with COUNT().

Re: How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot tabl

dailyfood — Fri, 14 Feb 2020 09:55:43 GMT

I'm still waiting for a solution to this.

I can't add an empty record where there no complaints. because I'm using COUNT() and this would give me count of 1 where there should be "zero" complaints.

There are number of things in QlikView that are more complicated than they should be 😞

Re: How Do you highlight the minimum count (could be zero) in a row in a multidimensional pivot tabl

Brett_Bleess — Wed, 11 Mar 2020 14:00:20 GMT

Best I have is the following Design Blog post on AGGR, might prompt some further thoughts for you. I will include the base link after that to this area in case you wish to search further in this area for other posts that may be helpful...

https://community.qlik.com/t5/Qlik-Design-Blog/Pitfalls-of-the-Aggr-function/ba-p/1463275

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

I see what Sunny was saying regarding the 0's having no underlying records, but I am not quite sure how to deal with that, hopefully the Design Blog area may provide you some better ideas.

Regards,
Brett