topic Re: Visual Cues in a Pivot Table in QlikView

Visual Cues in a Pivot Table

darrellbutler — Mon, 16 May 2011 15:31:12 GMT

Hi, I have a pivot table that has two dimensions Company & Month.

Company is a vertical dimension and Month horizontal, the data field is a dividend paid by each company. I want to compare dividends month on month by company. If May is greater than April this should be green, if it's less Red. I've tried entering a simple stament in visual cues =before([PPL},1,0) but this doesn't appear to work. Any help greatly appreciated.Darrell

Re: Visual Cues in a Pivot Table

matt_crowther — Mon, 16 May 2011 16:46:08 GMT

Darrell,

Makings of a solution attached.

If you need to remove the colour from the Total column just let me know.

(You can also use the 'Scramble' feature to hide sensitive data in the future)

Hope that helps,

Matt - Visual Analytics Ltd

Re: Visual Cues in a Pivot Table

matt_crowther — Mon, 16 May 2011 16:50:20 GMT

Darrell,

Improved version attached.

All the best,

Matt - Visual Analytics Ltd

Visual Cues in a Pivot Table

darrellbutler — Mon, 16 May 2011 16:55:37 GMT

Brilliant ! Cheers Matt this will do the trick ! Darrell