Set Analysis

srinivasa1 — Wed, 09 Jan 2013 05:44:20 GMT

im trying to change font color of text object useing below set analysis.but its only working if i assign value to some other variables then its working

v1=MaxString(if(Id='05' and Type=$(vType) and Key='$(=$(vKey))' and num#('$(=$(vCalc))')*100 < High and num#('$(=$(vCalc))')*100 > Low,Color, 0))

if i use v1 in text object calculated font color its working

but i wold like to use directley as font color. how i can achive that as below

=MaxString(if(Id='05' and Type=$(vType) and Key='$(=$(vKey))' and num#('$(=$(vCalc))')*100 < High and num#('$(=$(vCalc))')*100 > Low,Color, 0))

Thanks

Re: Set Analysis

Wed, 09 Jan 2013 10:13:00 GMT

Hi Srinivasa,

so you aggregate over multiple lines and take the 'highest color'?

What values are in the attribute color of your table, e.g. 'RGB(128,0,0)'?

MaxString(RGB(128,0,0)) and =MaxString(RGB(128,0,0)) work in the definition field for Text and Background Color.

Did you try without the = ?

Greets

Klaus

topic Re: Set Analysis in QlikView

Set Analysis

Re: Set Analysis