topic Colors/Icons in Pivot-table in QlikView

Colors/Icons in Pivot-table

Mon, 17 Oct 2011 07:27:34 GMT

Hello,

I have a Pivot-table where I per city per month per year show actual sales as well as forecasted sales.

In the colum for actual sales, I want to add eiter a small arrow or color to the cell to display based on if actual sales are higher or lower than forecasted.

Thank you in advance for your help.

Sincerely,

Jonas

Colors/Icons in Pivot-table

Anonymous — Mon, 17 Oct 2011 08:17:54 GMT

Hi Jonas,

Take a look here: http://community.qlik.com/message/149552#149552

I think there you find what you are looking for.

Good luck,

Dennis.

Colors/Icons in Pivot-table

Mon, 17 Oct 2011 08:20:48 GMT

Hi Jonas,

I use the coloring in the sixth tab "Visualization". There you can choose the column with the actual sales and could use the above or under field. One problem there is the = in both choices.

Otherwise you could expand the + before the expression. There you find background and textcolours. There you can add an expression like

if(Sum(actualSales) < Sum(forecastedSales), Red(135), Green(135))

Then the background or the number is red or green. So you can easy define more than two cases.

I hope, it helps a little bit.

regards

vicky

Colors/Icons in Pivot-table

Anonymous — Mon, 17 Oct 2011 08:39:07 GMT

Or take a look at Sunil Chauhan solution here: http://community.qlik.com/message/157319#157319

Colors/Icons in Pivot-table

Mon, 17 Oct 2011 08:41:24 GMT

Thank you both for quick and great feedback, problem solved

/Jonas

Re: Colors/Icons in Pivot-table

Mon, 17 Oct 2011 09:07:18 GMT

Hi Jonas,

Please u see my attached file may this one help you.

Good luck.

Regards

ENN