I’m new to QlikView, and need a little help with a problem.
In a pivot table, I want to mark the highest and the lowers value with colors. That should probably be easy enough – however a want to do this within the different dimensions and would also like to show the highest total. Is that possible?
- And do I need to handle something when the number might not be unique? Let’s say for example the lowest number is 30, but we got that number represented more than one time?
I use a table to test this from a course I took, so some of you might know it.
I want it to look something like this:
# Active customers got the following expression: Count(DISTINCT CustomerRecordCounter)
I set the expression in the background color.
I have tried some different stuff, but without any luck – jet.