Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

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
Honored Contributor

Re: Expression help for select collection of items

Like this:

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

Not applicable

Re: Expression help for select collection of items

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
Honored Contributor

Re: Expression help for select collection of items

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.

Community Browser