Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
agrimroquette
Contributor II

Expression Error

Hi,

i want to calculate number of [NAME OF PROJECT (Code - Title)]


where

"DIGIC" = 'No' and blank Values('  ')

and

"Is in MP"= 'Yes',


but below expression cannot include null or  blank values in Field "DIGIC", can anyone correct me?


Count ({<DIGIC = {"No", " "},"Is in MP"={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])

1 Solution

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Expression Error

May be this


Count ({<DIGIC = -{"Yes"},[Is in MP]={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])

Learning never stops.
2 Replies
pradosh_thakur
Honored Contributor II

Re: Expression Error

May be this


Count ({<DIGIC = -{"Yes"},[Is in MP]={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])

Learning never stops.
srivastalans
New Contributor III

Re: Expression Error

Hi Agrim,

Try this,

Count ({<DIGIC -= {"No",""},[Is in MP]={"Yes"}>} distinct [NAME OF PROJECT (Code - Title)])


You should add sign in-front of equal sign for DIGIC to exclude NO and Blank.



Community Browser