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

Announcements
Solving the Informatica Dilemma: On-Demand Briefing - Watch On Demand!
cancel
Showing results for 
Search instead for 
Did you mean: 
SDeLa131
Contributor III
Contributor III

Edit expression, need to select only specific order takers.

Currently the expression is =VCOHEAD_ORDERWRITER. But I need to add only select AB, EB, KMK for example how.

 

Labels (1)
2 Replies
steeefan
Luminary
Luminary

Try Only({<VCOHEAD_ORDERWRITER = {'AB','EB','KMK'}>} VCOHEAD_ORDERWRITER) as an expression in a table to only show these users.

References

You can also use the set expression in a SUM() formula to get the sum of sth. for only these users.

If this is now what you are looking for, please explain in detail what you are trying to achieve.

Chanty4u
MVP
MVP

May be this 

=Sum({<VCOHEAD_ORDERWRITER={"AB", "EB", "KMK"}>} VCOHEAD_ORDERWRITER)