Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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)