Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey there.
I have just started to learn how to use QlikView and really think it's an awesome program.
Anyways I am trying to do something with it which was quite simple to do with BO but I cannot figure out how to do it in QlikView.
I have the current view:
I am trying to highlight the max fields as such (this was done in photoshop, trying to get QlikView to do it itsel, I know I am supposed to do it under visual cues but it does not want to work)
And this is what I am trying to achieve:
Help would be greatly appreciated
Hello,
can you please put your qvw file so i can test on it
i tested visual cues on pivot table and it's working.
Best wishes
Thanks in advance for your help
Hi
Please check it now if that what you want
This is what I see with yours:
And this is kinda what I am trying to achieve:
But your helps at leasts kinda guides me in the right direction
I'm unclear why some of those cells are considered the max. Regardless, if you go to the expressions tab, and click on the little + next to the expression, it will show you some things you have control over. The first on the list is the background color. You can enter an expression there that evaluates to a color. For instance:
if(rank(count([Gekozen nummer]))=1,lightgreen())
That highlights the max Gekozen nummer in each column (ignoring the total at the bottom, which would always be highest). I'd guess that SOME expression would do the highlighting you want.