Problem with Formatting text color in pivot table with conditional expression

Thu, 30 Apr 2015 15:43:20 GMT

Hi everyone,

I have a pivot table, like below

	April	May	June
class1	100	200	100
class2	50	25	30
class 3	45	15	12

the number in the middle will be called Amount and its sum

Lets say i want to be able to test one and only 1 cell of this table regarding its values, compare it to a lower and higher value and change the color depending on when this value is situated

For instance, i want to check the April Class 2. If the value is bigger than 55 then it goes RED, if it is lower than 40, it goes GREEN, else it goes amber. Right now the Value is 50 so it should be YELLOW.

on the calculated expression of that pivot, i click on the + , went to Text Color , and applied the following expression :

if ( Month = 'April' ,

if ( class = 'class2'

if ( Amount > 55, red(),

if ( Amount < 40 , green(),

yellow()

)

The result is : that number is always Green .... no matter what i do, so it means that it jumped to the second if .

I tried a lot of possibilities with my formula, and i never be able to make it.

Anyone to help ?

thanks a lot

Re: Problem with Formatting text color in pivot table with conditional expression

Gysbert_Wassenaar — Thu, 30 Apr 2015 16:24:08 GMT

Can you post a qlikview document that demonstrates the problem?

Re: Problem with Formatting text color in pivot table with conditional expression

buzzy996 — Thu, 30 Apr 2015 16:55:22 GMT

can u try some thing like this,

topic Problem with Formatting text color in pivot table with conditional expression in QlikView

Problem with Formatting text color in pivot table with conditional expression

Re: Problem with Formatting text color in pivot table with conditional expression

Re: Problem with Formatting text color in pivot table with conditional expression