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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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.