topic Re: HELP: QlikView partial sum pivot table formatting in QlikView

HELP: QlikView partial sum pivot table formatting

Tue, 12 Jul 2011 12:01:44 GMT

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

HELP: QlikView partial sum pivot table formatting

Wed, 13 Jul 2011 08:59:10 GMT

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

Re: HELP: QlikView partial sum pivot table formatting

Wed, 13 Jul 2011 11:02:21 GMT

Thanks in advance for your help

Re: HELP: QlikView partial sum pivot table formatting

Wed, 13 Jul 2011 13:22:24 GMT

Please check it now if that what you want

Re: HELP: QlikView partial sum pivot table formatting

Wed, 13 Jul 2011 16:32:52 GMT

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

Re: HELP: QlikView partial sum pivot table formatting

johnw — Wed, 13 Jul 2011 22:55:18 GMT

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.