topic Re: Pivot Table in QlikView

Pivot Table

Mon, 25 Nov 2013 10:11:36 GMT

Hi All,

I want to compare the column with previous column value and have to give the backround color based on that. (See the attchment).

Any idea for that?

Re: Pivot Table

Anonymous — Mon, 25 Nov 2013 10:18:32 GMT

HI,

using this expression if(column(1)=column(2),Yellow(),if(column(1)>column(2),Red(),green())

in background color condition in column(2) expression you need to column no to change based on your table.,

Re: Pivot Table

Mon, 25 Nov 2013 12:53:29 GMT

Hi Srikumar,

Thanks for reply.But Its not different columns (expressions). Its same expressions with different dimensions means Build1 and Build2 are the data under Build dimension.So I cant use this expression.

Re: Pivot Table

Mon, 25 Nov 2013 13:11:43 GMT

hi,

you can use above function.

Re: Pivot Table

Anonymous — Mon, 25 Nov 2013 13:13:47 GMT

Hi Tamil,

if(Build='Build2',

if(sum({$<Build={"Build1"}>}value)>sum({$<Build={"Build1"}>}value),red(),

if(sum({$<Build={"Build1"}>}value)=sum({$<Build={"Build1"}>}value),Yellow(),

if(sum({$<Build={"Build1"}>}value)<sum({$<Build={"Build1"}>}value),Green()

))))

use Expression in the Expression Background color,

it will helpful ..,