topic Re: set expression in App Development

set expression

hargovind_singh — Fri, 19 Mar 2021 12:31:55 GMT

Hi All,

I am stuck with set expression in qliksense.

I am getting correct values for 2020 in

sum({<Fin_Period={'$(=upper(SUBFIELD(parameter_code,':', -1)))$(=right(year(today())-1,2))'},Schedule_Type-={'ACC'}>}Amount_Millions)

bt when i am using this,

=sum({$<Fin_Period={'$(=UPPER(SUBFIELD(parameter_code,':', -1)))$(=right(GetFieldSelections(Year1)-1,2))'},Schedule_Type-={'ACC'}>}Amount_Millions)

I am getting 0.000 thats not a correct value.

so could someone pls help me .

Thanks

Re: set expression

agigliotti — Fri, 19 Mar 2021 13:24:31 GMT

Hi @hargovind_singh

what do you get with the below expressions?

right(GetFieldSelections(Year1)-1,2)
right(year(today())-1,2)

do they match?

Re: set expression

hargovind_singh — Fri, 19 Mar 2021 13:57:52 GMT

Yes they match, like

right(GetFieldSelections(Year1)-1,2) giving whatever election i m making let say 2021 then it will give right(2021-1,2) => 19

and right(year(today())-1,2) also giving same as 19

Re: set expression

hargovind_singh — Fri, 19 Mar 2021 13:58:43 GMT

But still its not working what can be a possible solution?

Re: set expression

agigliotti — Fri, 19 Mar 2021 14:06:17 GMT

what do you get for the below expressions?

=UPPER(SUBFIELD(parameter_code,':', -1))
=right(GetFieldSelections(Year1)-1,2)

Re: set expression

hargovind_singh — Fri, 19 Mar 2021 14:08:50 GMT

UPPER(SUBFIELD(parameter_code,':', -1)) gives like JAN, FEB,MAR etc....

right(GetFieldSelections(Year1)-1,2) gives like 20,19,18 etc....

based on selections in filters Year1 and parameter_code

Re: set expression

agigliotti — Fri, 19 Mar 2021 14:20:21 GMT

how does "Fin_Period" field looks like?

Re: set expression

hargovind_singh — Fri, 19 Mar 2021 14:27:56 GMT

like Jan, Feb,Mar

Re: set expression

agigliotti — Fri, 19 Mar 2021 14:32:45 GMT

I can't understand , could you share a sample app with mock data to look at?

Re: set expression

hargovind_singh — Fri, 19 Mar 2021 14:41:50 GMT

sum({<Fin_Period={'$(=upper(SUBFIELD(parameter_code,':', -1)))$(=right(year(today())-1,2))'},Schedule_Type-={'ACC'}>}Amount_Millions)

and

sum({<Fin_Period={'$(=upper(SUBFIELD(parameter_code,':', -1)))$(=right(GetFieldSelections(Year1)-1,2))'},Schedule_Type-={'ACC'}>}Amount_Millions)

in console both are giving same value like this in attached image,