set expression

[hargovind_singh]

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 

[agigliotti]

Hi @hargovind_singh 

what do you get with the below expressions?

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

do they match?

[hargovind_singh]

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

[hargovind_singh]

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

[agigliotti]

what do you get for the below expressions?

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

[hargovind_singh]

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

[agigliotti]

how does "Fin_Period" field looks like?

[hargovind_singh]

like Jan, Feb,Mar 

[agigliotti]

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

[hargovind_singh]

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,