Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarvenkategow
Contributor
Contributor

Set Analysis Expression retunes zero

Here is my expression : Sum({<description={'$(Vtrend2)'}>}value)

Variable: =SubField(GetFieldSelections(description),',',2)

i have added description as the filter and selecting the two values in the filter

its retuning as 0 , while I expect more than 0. please help.

Labels (1)
3 Replies
MayilVahanan

Hi

Variables will return only 2nd description, is it ur requirement like that? or u want to display all the selected description info?

for all selected description, try like below

Variable: = If(GetselectedCount(description) > 0, Concat(DISTINCT chr(39)&description, chr(39)&',')&chr(39))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
sagarvenkategow
Contributor
Contributor
Author

Hi @MayilVahanan 

Variables will return only 2nd description, so in the set analysis i am trying to set that value.

MayilVahanan

In that case, did you check the variable - "Vtrend2" values whether it's assigning the correct value or not. And also, confirm those has values or not.

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.