topic Re: If statement for text color expression in QlikView

If statement for text color expression

akpofureenughwu — Tue, 11 Apr 2017 04:43:10 GMT

Good day everyone..

I'm using this expression

if((count({$<[Project Status] = {'Completed'} >} Community )/ (Count(Community))))>=0.7,yellow(),if((count({$<[Project Status] = {'Completed'} >} Community )/ (Count(Community))))<=0.69,lightgreen())))..... This is for the PRogress indicator... see attached...

I'm getting error in expression...

I tried bugging it but to no avail..

Please help.

Regards

Re: If statement for text color expression

Anil_Babu_Samineni — Tue, 11 Apr 2017 04:48:46 GMT

Is it possible to attach QVF file

Re: If statement for text color expression

Muthu — Tue, 11 Apr 2017 05:33:35 GMT

Hi,

Try this expression.

if(count({$<[Project Status] = {'Completed'} >}Community)

/Count(Community)>=0.7,Yellow(),

if(count({$<[Project Status] = {'Completed'} >} Community)

/Count(Community)<0.69,LightGreen()))