Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression help for select collection of items

Hi guys,

I have the below expression however it only uses the last "identifier" rather then all of them.

Sum ({$<[concepts_id]={'258'},[identifier]={'ES0081'},[identifier]={'ES0065'},[identifier]={'ES0231'},[identifier]={'ES0182'},[identifier]={'ES0128'},[identifier]={'ES0075'},[identifier]={'ES0049'},[identifier]={'ES0198'},[identifier]={'ES0224'}>}Sales_value)

So I want a sum of concept_id 258 but only include those identifiers.

Thanks

3 Replies
stigchel
Partner - Master
Partner - Master

Like this:

Sum ({$<[concepts_id]={'258'},[identifier]={'ES0081','ES0065','ES0231','ES0182','ES0128','ES0075','ES0049','ES0198','ES0224'}>}Sales_value)

Not applicable
Author

I am using this on a combo chart and I want that expression the ignore any selection. So when I select Idenifier ES0182, the above expression still calculates the Sum of them all but I have another line that just calculates the sum of the selected identifier.

stigchel
Partner - Master
Partner - Master

I'm not sure what your question is....

If it's how to calculate the sum of the selected identifier on the other line, just erase the identifier= bit out of the expression, so

Sum ({$<[concepts_id]={'258'}>}Sales_value)


If this is not your question please try to explain what is.