Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

What is the error in this expression?

HI All,

I am not able to figure out the issue with this expression:

=Count({<upper([Curr Status])={'MET'}>}Key)

Please help.

Thanks

Sam

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

And if you really want to insist on UPPER, you can do it like this:

=Count({<[Curr Status]={"=UPPER([Curr Status])='MET' "}>} Key)

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

View solution in original post

17 Replies
Highlighted

You cannot use a function (Upper) before = in your set modifier.

You might want to do it in the script itself or use MET as it may be spelled in your database.

HTH

Best,

S

Highlighted
MVP
MVP

maybe without set analysis

count(if(upper([Curr Status])='MET', Key))

Highlighted
Champion III
Champion III

I think that it is not case sensitive at all, that is there is no difference between

=Count({<[Curr Status]={'MET'}>}Key)

and

=Count({<[Curr Status]={'met'}>}Key)

Highlighted
MVP & Luminary
MVP & Luminary

And if you really want to insist on UPPER, you can do it like this:

=Count({<[Curr Status]={"=UPPER([Curr Status])='MET' "}>} Key)

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

View solution in original post

Highlighted
Contributor III
Contributor III

Thanks all for your response!

Highlighted
MVP
MVP

1.jpg

Highlighted
MVP & Luminary
MVP & Luminary

You see Michael, it is case sensitive after all!

Oleg Troyansky

Masters Summit for Qlik is going virtual! Nov 18th - I'll teach Advanced Set Analysis and AGGR

Highlighted
Champion III
Champion III

Thanks for testing!

Highlighted
Champion III
Champion III

I see, but it is very strange.  I'm just re-testing this simple expression:

count ({<Field={"*abc*"}>} Field)

and

count ({<Field={"*ABC*"}>} Field)

They return the same exact result.  The actual values in the Field are all capital.