topic how to do this on a pivot table in QlikView https://community.qlik.com/t5/QlikView/how-to-do-this-on-a-pivot-table/m-p/362349#M134687 <HTML><HEAD></HEAD><BODY><P>Dear I got a pivot table with dimensions Country, Shop</P><P>and showing the sales variance</P><P>and in another expression I'm displaying a column with an image which is either green if the variance is positive or red if the variance is negative</P><P></P><P>Now if the country dimension is collapsed I'm getting a greed image if the total is positive or red if the total of variance is negative</P><P>However what I want is the following:</P><P>if under the country the variance of some shops is nevative and other positive then display a third image which is gray otherwise if all vairances by shop are positive then show green else show the red image</P><P></P><P></P><P>Check attached image for more elaboration</P></BODY></HTML> Thu, 21 Jun 2012 10:47:51 GMT ali_hijazi 2012-06-21T10:47:51Z how to do this on a pivot table https://community.qlik.com/t5/QlikView/how-to-do-this-on-a-pivot-table/m-p/362349#M134687 <HTML><HEAD></HEAD><BODY><P>Dear I got a pivot table with dimensions Country, Shop</P><P>and showing the sales variance</P><P>and in another expression I'm displaying a column with an image which is either green if the variance is positive or red if the variance is negative</P><P></P><P>Now if the country dimension is collapsed I'm getting a greed image if the total is positive or red if the total of variance is negative</P><P>However what I want is the following:</P><P>if under the country the variance of some shops is nevative and other positive then display a third image which is gray otherwise if all vairances by shop are positive then show green else show the red image</P><P></P><P></P><P>Check attached image for more elaboration</P></BODY></HTML> Thu, 21 Jun 2012 10:47:51 GMT https://community.qlik.com/t5/QlikView/how-to-do-this-on-a-pivot-table/m-p/362349#M134687 ali_hijazi 2012-06-21T10:47:51Z