topic Re: Selection different color in QlikView

Selection different color

Anonymous — Thu, 17 Oct 2013 21:08:17 GMT

Hi community,

Do you know how to change color for selected tag in Pivot table?

Or maybe show only this tag. I'd prefer highlight the tag.

Thanks,

Re: Selection different color

jpapador — Thu, 17 Oct 2013 21:12:54 GMT

What do you mean by selected tag, do you mean change the selection color from green to yellow, or change the background color. If it is background color, try the following.

In your expression editor, hit the plus sign on your expression and in the background color area use:

if([Purpose of Visit] = 'Make Purchase', Yellow())

You can also do this on the Purpose of visit field on the dimensions tab.

Re: Selection different color

Anonymous — Thu, 17 Oct 2013 21:15:47 GMT

I want to dynamically change color, not only for expression.

Re: Selection different color

jpapador — Thu, 17 Oct 2013 21:18:00 GMT

What are your conditions for determining the change in color?

Re: Selection different color

Anonymous — Thu, 17 Oct 2013 21:19:45 GMT

When user clicks on a row representing a POV. What he selected, that should change color

Re: Selection different color

jpapador — Thu, 17 Oct 2013 21:24:51 GMT

Do you have a sample file?

Re: Selection different color

Thu, 17 Oct 2013 23:11:27 GMT

Got it, a partener teach me how to do this, look in your expresion in the part of the set Analysis i used this:

Sum({$<[Carrier Group]=>} [# Departures Performed])

This expression I used to say that the selected fields remain intact. Due to th e following "[Carrrier Group]="

You have a table where you want the results to be colored only,in this case Yellow.

Now to get colored the background in the same expresion go to "BackGroundColor" and use somethig like this :

if((Sum( [# Departures Performed])) > 0,Yellow())

In my case only work with [Carrier Group] ,because it's the only one assigned in the "SET ANALYSYS".

Good luck, sorry for the bad english!

Regards.