topic Re: help required in set expression in QlikView

help required in set expression

sayadutt — Fri, 29 May 2015 10:25:57 GMT

Hi Team,

I have an expression like below:

if(count({$<[Test Cases ]={'In Progress', 'Completed'}>} [Project Name ])/count({$<[Test Cases ]=>} [Project Name ])=1, green(), red())

Above expression counts the number of In Progress and Completed test cases out of TOTAL test cases and determine Green or Red.

Now I need to modify the above expression and instead of only In Progress and Completed ones I need to consider ALL where length is greater than 1.

can you please modify my current expression...(orange part) and replace that with len([Test Cases ]) > 1.

(in short I am trying to ignore the blank values but it does not show up in null() function ). So they are not really null but can be ignored if we consider length greater than 1.

Thanks

Re: help required in set expression

robert_mika — Fri, 29 May 2015 10:30:47 GMT

Try

if(count({$<[Test Cases ]={"=Len(Test Cases ) > 1"}>} [Project Name ])/count({$<[Test Cases ]=>} [Project Name ])=1, green(), red())

Re: help required in set expression

sunny_talwar — Fri, 29 May 2015 10:31:23 GMT

Length of Test Cases in days? Are you calculating the length somewhere in your script? Or do you have start and end date?

Re: help required in set expression

PrashantSangle — Fri, 29 May 2015 10:36:31 GMT

Hi,

Try like

if(count(if(not isnull([Test Cases]) or len(trim([Test Cases]))>0,[Project Name ] )

count({$<[Test Cases ]=>} [Project Name ])=1, green(), red())

Regards

Re: help required in set expression

sunny_talwar — Fri, 29 May 2015 10:41:58 GMT

I guess I was thinking about incorrectly. I thought we were looking at length in time , wherein he might be looking for length of the field itself.