topic Re: Conditional Formatting on a Pivot Table in QlikView

Conditional Formatting on a Pivot Table

Thu, 26 Mar 2015 13:49:35 GMT

I attached a qvw where i created a pivot table showing the count of sales per employee for each business week.

I want to color code the people to tell me who hasn't sold anything in 1 week, 2 weeks , 3 + weeks and then someone who has null/zeros for all weeks shown (never sold anything). I need the conditional formula for the background to calculate from the most current week in the data.

I don't care about which rgb codes at this time that are used.

Any suggestions are greatly appreciated.

Thanks,

Robyn

Re: Conditional Formatting on a Pivot Table

a_mullick — Mon, 30 Mar 2015 14:48:42 GMT

Hi Robyn,

You've probably thought of this already, but I think the easier solution is test the value of the expression cell. If it's zero, then colour the background. I can't find a way to conditionally highlight the dimension (based on an expression) so would be interested to hear of a solution.

Thanks,

Azam

Re: Conditional Formatting on a Pivot Table

stigchel — Mon, 30 Mar 2015 15:11:51 GMT

For the Dimension AND Expression click on the + sign, it will expand and there is a background color option, you can use the following expression

=if(Column(1)=0,rgb(200,0,0))