Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Register for Events and Webinars directly from Qlik Community: http://bit.ly/2Vpnenx
Not applicable

HELP: QlikView partial sum pivot table formatting

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:

http://i.imgur.com/LzRZj.png

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:

http://i.imgur.com/BCKmv.png

Help would be greatly appreciated

5 Replies
Highlighted
Not applicable

HELP: QlikView partial sum pivot table formatting

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

Highlighted
Not applicable

Re: HELP: QlikView partial sum pivot table formatting

Thanks in advance for your help

Highlighted
Not applicable

Re: HELP: QlikView partial sum pivot table formatting

Hi

Please check it now if that what you want

Highlighted
Not applicable

Re: HELP: QlikView partial sum pivot table formatting

This is what I see with yours:

http://i.imgur.com/BeJDx.png

And this is kinda what I am trying to achieve:

http://i.imgur.com/BCKmv.png

But your helps at leasts kinda guides me in the right direction

Highlighted
MVP
MVP

Re: HELP: QlikView partial sum pivot table formatting

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.