topic Re: pivot table in QlikView

pivot table

mario-sarkis — Thu, 01 Oct 2015 11:34:38 GMT

this is what i need and hope you can help have a pivot table:

i need a red color in Expression 2 is Expression 2 greater then 1% of Expression 1

Any one can help ?

krishna20 — Thu, 01 Oct 2015 12:19:52 GMT

Hi,

Goto Expressions tab-> Select your Second Expression -> Expand it by clicking + -> Selct Text Color-> Write your Expression like this.

If(Sum( Field in Expression 2)> Sum(Field in Expression1), Red(), Black())

tresB — Thu, 01 Oct 2015 12:20:13 GMT

Try like shown in the image below:

Note: Exp1, Exp2 are actually labels of the expressions. For %, you might have to compare like: If ( (Exp1*10)>1, red())