topic Re: Error in QlikView

Error

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

Hi Expertise

Iam using the below expression to make the colour changes for the values .

Can please somone correct this

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)<5,Green(),

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=5,Orange(),

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=5,Red(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)<20,Green(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=20,Orange(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)>20,Red(),

Thanks in Advance

Anil_Babu_Samineni — Wed, 20 Sep 2017 04:44:40 GMT

May be try this for all expressions

if((Days>0 and Days<5) and ((count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Count({<Env={'A'}>}ID))<5,Green(),

....... // In the last part of Count you used Dept not sure the function is available in Qlikview

smilingjohn — Wed, 20 Sep 2017 04:47:31 GMT

Hi Anil.

Sorry it was a mistake ..This is the right one

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)<5,Green(),

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=5,Orange(),

if(Days>0 and <5) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=5,Red(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)<20,Green(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)=20,Orange(),

if(Days>8 and <14) and (count({<Dept={'A'}>}ID)-count({<Dept={'A'},Status={'Pass'}>}ID))/Dept({<Dept={'A'}>}ID)>20,Red(),

How should i correct this one to get the desire result

Anil_Babu_Samineni — Wed, 20 Sep 2017 07:51:33 GMT

When you say, This is right one you are not applying anything where i recommend. Looks like you got the solution and assumed answer as flag..