topic Re: Set analysis in QlikView

Set analysis

smilingjohn — Wed, 25 Nov 2020 16:16:04 GMT

HI All ,

Iam trying to include the below expression into set analysis but its not executing

Can the expertise please help me ..

count(if(IsNull(Closed), Resolved,Closed) This expression needs to be included in the below set analysis...

This says count of closed in if closed are null the count Resolved ...now the requirement is to pass certain fields ..therefore iam trying the below expression .

=if(if(count({<Class={'Class 1','Class 2'},Dys={"=Days >=0 and Days <=7"}>} isnull(Closed),Resolved,Closed)<>0,Green(),Red()))

Thanks in advance

Re: Set analysis

swuehl — Wed, 20 Sep 2017 09:37:24 GMT

Not really sure, but maybe

=if(

count({<Class={'Class 1','Class 2'},Dys={"=Days >=0 and Days <=7"}>}

if( isnull(Closed),Resolved,Closed)

)

<>0,Green(),Red()

)

Re: Set analysis

Chanty4u — Wed, 20 Sep 2017 09:38:51 GMT

try this

=if(if(count({<Class={'Class 1','Class 2'},Closed={' '},Dys={"=Days >=0 and Days <=7"}>} Resolved,Closed)<>0,Green(),Red()))

Re: Set analysis

smilingjohn — Wed, 20 Sep 2017 09:43:36 GMT

Hi CHanty this is giving the error

Re: Set analysis

Chanty4u — Wed, 20 Sep 2017 09:47:30 GMT

waht error your getting?

Re: Set analysis

smilingjohn — Wed, 20 Sep 2017 09:50:29 GMT

Error in epression , a red mark after closed <>0

Re: Set analysis

smilingjohn — Wed, 20 Sep 2017 09:50:55 GMT

it says error in expression

Re: Set analysis

Chanty4u — Wed, 20 Sep 2017 09:54:56 GMT

can you share the screen shot of it?

Re: Set analysis

Anil_Babu_Samineni — Wed, 20 Sep 2017 09:55:20 GMT

Try this first alone and check how it returns?

If(count({<Class={'Class 1','Class 2'},Days={"=Days >=0 and Days <=7"}>} Closed) <> 0,Green(),Red())

Re: Set analysis

andrei_delta — Wed, 20 Sep 2017 09:55:36 GMT

Hello,

you misspelled the field Days.

From your code: Dys={"=Days >=0 and Days <=7"}>}

Hope it helped,

Andrei

Re: Set analysis

devarasu07 — Wed, 20 Sep 2017 10:20:46 GMT

Hi,

you can try like this.

=if(

count({<Class={'Class 1','Class 2'},Dys={"=Days >=0"}>}

if( isnull(Closed),Resolved,Closed)

) * count({<Class={'Class 1','Class 2'},Dys={"= Days <=7"}>}

if( isnull(Closed),Resolved,Closed)

)

<>0,Green(),Red()

)

Re: Set analysis

andrei_delta — Wed, 20 Sep 2017 11:08:26 GMT

It was incorrect and now is correct ? How come?