Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Krish
Contributor III
Contributor III

Set command issues

I have a condition for a text object where I have to select employees whose ID starts with 4.

I have written sum({<empid  = {"4*"}>}sal)

This works fine for that condition. But when I select a particular employee like 4000 it is not filtering it out.

How can this be done.

Thanks.

1 Reply
Vegar
MVP
MVP

If by filtering you mean making an selection in the empid field then you can solve it using the following adjusted expression .

sum({<empid *= {"4*"}>}sal)