Set Expression not working using variable

Wed, 23 Jul 2025 14:48:52 GMT

Dear Team, My set expression

Sum({< [Ledger] = {"41*"},Year = {'$(=GetFieldSelections(Year)-1)'} >}Ballance)

is perfectly working when i use as an expression in Qlik sense sheet. But as a Set Variable in the script it is not working.

SET lsale = Sum({< [Ledger] = {"41*"},Year = {'$(=GetFieldSelections(Year)-1)'} >}Ballance);

Expression in sheet = $(lsale)

All other expressions are working via SET, but wherever i use Year = {'$(=GetFieldSelections(Year)-1)'} for prior year of selected year, it is showing 0 as output.

I tried SET Previousyear = GetFieldSelections(Year)-1); then used in set but still not working.

Please suggest the wayout...

Thanks

Shiv

Re: Set Expression not working using variable

Gysbert_Wassenaar — Tue, 03 Mar 2015 14:40:37 GMT

Try LET lsale = 'Sum({< [Ledger] = {"41*"},Year = {"$' & '(=GetFieldSelections(Year)-1)"} >}Ballance)' ;

SET lsale = Sum({< [Ledger] = {"41*"},Year = {'@(=GetFieldSelections(Year)-1)'} >}Ballance);

LET lsale = replace($(lsale),'@','$');

topic Re: Set Expression not working using variable in Archived Groups

Set Expression not working using variable

Re: Set Expression not working using variable