topic Re: Dynamic variable not working in expression in QlikView

Dynamic variable not working in expression

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

I have created a variable to get the maximum month of all the selected month.

Variable Name : Max Month

Definition : SubField(GetFieldSelections([Month],',',GetSelectedCount([Month])),',',GetSelectedCount([Month]))

I am trying to use it in a sum function but its not working. Looks like some syntax error.

Please help.

Thing I have tried

=sum({$<Geo={"EUZ"} , Month={$(Max Month)}>} Actual) --- Error

=sum({$<Geo={"EUZ"} , Month={'$(Max Month)'}>} Actual) ---- Giving 0 which is not the write answer

=sum({$<Geo={"EUZ"} , Month={$(=Max Month)}>}Actual1) --- Again giving 0

tamilarasu — Wed, 27 Jul 2016 07:31:16 GMT

Hi Anvita,

Try this expression

=sum({$<Geo={"EUZ"} , Month={"$(=$(Max Month))"}>}Actual1)

Add equal sign in the variable definition and try,

=SubField(GetFieldSelections([Month],',',GetSelectedCount([Month])),',',GetSelectedCount([Month]))

vinieme12 — Wed, 27 Jul 2016 07:34:30 GMT

Isn't Max (Getfieldselections ([Month])) working ?

May be even Max ([Month])

Why are you using subfield??

Frank_Hartmann — Wed, 27 Jul 2016 07:55:51 GMT

perhaps this:

=sum({$<Geo={"EUZ"} , Month={'=$(=Max Month)'}>}Actual1)

Anonymous — Wed, 27 Jul 2016 08:48:55 GMT

Thanks Tamil Nagaraj !!

The expression you have given works nicely !

Anonymous — Wed, 27 Jul 2016 08:50:22 GMT

Thanks everyone for your inputs. Much appreciated.