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

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