Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

aschmeelk
New Contributor II

Getting error in set expression and don't know why.

I am using the following code to determine a value:

Count( {<DaysOverDue > {1}>} distinct Work_Order_Number)

where DaysOverDue is a numeric value.

The error is 'error in expression: '}' expected'. I can't see where a brace is missing.

Any help will be greatly appreciated!

3 Replies

Re: Getting error in set expression and don't know why.

Are you looking for one of these?

Count({<DaysOverDue = {1}>} DISTINCT Work_Order_Number)

or

Count({<DaysOverDue = {">1"}>} DISTINCT Work_Order_Number)

aschmeelk
New Contributor II

Re: Getting error in set expression and don't know why.

The latter of the two. ok so the > has to be in the braces with the cardinal number and in quotes.  I didn't realize that. Thank you!

Re: Getting error in set expression and don't know why.

Yup

Community Browser