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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

how to add or combine two set expressions

Hi All,

I have two expressions, can we add the two set expressions similar to below

var1=Sum({$<TagName={A1}>}Journeys)

var2=Sum({$<TagName={A2}>}Journeys)

can i add the above set expressions as below expression.

Total=Sum({$<TagName={A1}>+<TagName={A2}>}journeys)

Thank you

1 Solution

Accepted Solutions
trdandamudi
Master II
Master II

May be as below:

=Sum({$<TagName={'A1','A2'}>}journeys)

View solution in original post

4 Replies
trdandamudi
Master II
Master II

May be as below:

=Sum({$<TagName={'A1','A2'}>}journeys)

syukyo_zhu
Creator III
Creator III

yes you can.

If your TagName is the same, your can use these

Sum({$<TagName={A1}>+{A2}>}journeys)

Sum({$<TagName={A1,A2}>}journeys)


psankepalli
Partner - Creator III
Partner - Creator III

you can use this way,

variable v_Tag= getcurrentselections(TagName)

and use that variable in Set Analysis

Total = Sum({$<=$(v_Tag>}Journeys)

like this you can combine it more dynamically.

Thanks

PR

Not applicable
Author

Those both expression are working

Thanks