Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
smilingjohn
Creator III
Creator III

Error

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

3 Replies
Anil_Babu_Samineni

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
smilingjohn
Creator III
Creator III
Author

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

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..

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)