Line chart text color

Anonymous — Tue, 21 May 2013 19:07:57 GMT

Hi all,

Please help me with idea

I have line chart.

Dimension:MYear

Expression: Label-> Master avg([qID_1_Overall Experience])

Text color:

If((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2)>30,

If(([Master]-Above([Master]))<0 and (1-TDIST(fabs(([Master]-Above([Master]))/SQRT(((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience])))/

(count([qID_1_Overall Experience])*Above(count([qID_1_Overall Experience]))))*(sqr(Stdev([qID_1_Overall Experience]))*(count([qID_1_Overall Experience])-1)+

Above(sqr(Stdev([qID_1_Overall Experience])))*(Above(count([qID_1_Overall Experience]))-1))/(count([qID_1_Overall Experience])+

Above(count([qID_1_Overall Experience]))-2))),count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2,2))>=.95, RGB(255,0,0),

If(([Master]-Above([Master]))>0 and (1-TDIST(fabs(([Master]-Above([Master]))/SQRT(((count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience])))/

(count([qID_1_Overall Experience])*Above(count([qID_1_Overall Experience]))))*(sqr(Stdev([qID_1_Overall Experience]))*(count([qID_1_Overall Experience])-1)+

Above(sqr(Stdev([qID_1_Overall Experience])))*(Above(count([qID_1_Overall Experience]))-1))/(count([qID_1_Overall Experience])+

Above(count([qID_1_Overall Experience]))-2))),count([qID_1_Overall Experience])+Above(count([qID_1_Overall Experience]))-2,2))>=.95, RGB(0,150,0)))

,RGB(0,0,0))

I have first result and where my conditions work. What condition can I add to have all results?

Thanks,

Re: Line chart text color

Anonymous — Wed, 22 May 2013 14:03:55 GMT

Any ideas?

topic Line chart text color in QlikView

Line chart text color

Re: Line chart text color