Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
SDeLa131
Contributor II
Contributor II

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)