Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
dailyfood
New Contributor II

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

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 highlightThis is what I want to highlight

3 Replies
Highlighted

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

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.

Highlighted
dailyfood
New Contributor II

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

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(). 

Highlighted
dailyfood
New Contributor II

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

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 😞