topic Re: Re: Pivot Table cell background color in QlikView

Pivot Table cell background color

Tue, 06 May 2014 17:40:34 GMT

Hi all,

I have a Pivot Table that sums sales for each product during the last full 365 days.

My Dimensions are:

Product Class (like autos, shirts, pants)

Product Name (like race car, tank top, grungy jeans)

CalendarMonthYear May-2013, June-2013 .. . . Apr - 2014)

My Expression is:

SUM({<Product_ProductName = >}Order_Counter)

What I want to do is change the background color of each sell to red if this months sales are lower than last months sales and green if the are greater.

Thank you all for looking and your help.

Re: Pivot Table cell background color

Tue, 06 May 2014 18:25:53 GMT

Click the plus sign next to the expression, Click on the background color and add the expression

VLASTMONTH - Variable which holds last month.

if(count(SUM({<Product_ProductName = >}Order_Counter)) > SUM({<Product_ProductName = , Month = 'VLASTMONTH'>}Order_Counter) , Red(), green())

Re: Re: Pivot Table cell background color

Tue, 06 May 2014 20:40:04 GMT

Thanks for the reply, but I am not using a variable.

I would have to base this off the Dimension CalendarMonthYear

So this is kinda how it looks currently:

Product	Aug-2013	Dec-2013
1234	2345	2256

Re: Re: Pivot Table cell background color

its_anandrjs — Tue, 06 May 2014 21:00:17 GMT

In the expression by click on + in background color write

If( SUM({<Product_ProductName = >}Order_Counter) <

Below(TOTAL SUM({<Product_ProductName = >}Order_Counter) ) , Red( ) , Green( ))

Re: Re: Pivot Table cell background color

Tue, 06 May 2014 22:46:06 GMT

I think you got me on the right track, but since I want to evaluate the sales from last month compared to this month in the diminsion, I think it would be correct to use Before and not below.

If( SUM({<Product_ProductName = >}Order_Counter) <

before(TOTAL SUM({<Product_ProductName = >}Order_Counter) ) , Red( ) , Green( ))