topic Re: Set Analysis Expression retunes zero in QlikView

Set Analysis Expression retunes zero

sagarvenkategow — Tue, 06 Dec 2022 08:58:53 GMT

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.

Re: Set Analysis Expression retunes zero

MayilVahanan — Tue, 06 Dec 2022 10:05:07 GMT

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))

Re: Set Analysis Expression retunes zero

sagarvenkategow — Tue, 06 Dec 2022 11:45:03 GMT

Hi @MayilVahanan

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

Re: Set Analysis Expression retunes zero

MayilVahanan — Thu, 08 Dec 2022 06:42:30 GMT

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.