Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

akpofureenughwu
Contributor II

If statement for text color expression

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

1 Solution

Accepted Solutions
Muthu
Contributor II

Re: If statement for text color expression

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()))

2 Replies

Re: If statement for text color expression

Is it possible to attach QVF file

Muthu
Contributor II

Re: If statement for text color expression

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()))

Community Browser