topic Color Mix wizard in QlikView

Color Mix wizard

Tue, 28 Sep 2010 06:33:34 GMT

HI,

I like to give two different color based on expression result using color mix wizard ,the formula used in expression is

(Sum([Units])/ Sum(total [Units])* 100 - Sum({1<PeriodID={$(=PeriodID-1)}>}[Units])/ Sum(total [Units])*100)/1000

if the expression value > o it should display color with green and the value less than o(zero) should display with red color.

Plz,help me out wat expression to be given in color mix value expression and in the upper and lower (..) areas.

THANKS IN ADVANCE

Color Mix wizard

Tue, 28 Sep 2010 08:00:43 GMT

hi,

if i am able to understand your problem ,

if(round((Sum([Units])/ Sum(total [Units])* 100 - Sum({1<PeriodID={$(=PeriodID-1)}>}[Units])/ Sum(total [Units])*100)/1000 ) >0,green(),red())

regards,

Ravi

Color Mix wizard

Tue, 28 Sep 2010 08:04:45 GMT

Go to visual cues and set the upper to whatever you wish to, and set the lower to 0 so that the lower than 0 number will display red and the higher numbers will display green

Color Mix wizard

Tue, 28 Sep 2010 08:05:08 GMT

Hi,

its working

can you explain this with using colormix wizard to display the color.

if possible explain in detail with screen shots..

thanks,,,

Color Mix wizard

Tue, 28 Sep 2010 08:06:10 GMT

Hi,

I agree with Ravi..just an additional info you can put this formula in the font color of the chart you are doing.

Regards,

Color Mix wizard

Tue, 28 Sep 2010 08:11:01 GMT

Hi,

Any other option like this in charts(bar chart).

pls,,if possible explain with screenshots..