Using variable in set analysis

[risabhroy_03]

I have created a variable named A_GFPL_MFG_Warehouse_Pivot_Flag which either gives 1 or 0.

I want to use this variable inside my set expression but when I place it my whole data vanishes.

Please help.

$(A_GFPL_MFG_Warehouse_Pivot_Flag)={1},

[ali_hijazi]

Hello
you can't use your variable as such

you can do something like this in your expression:
if ($(A_GFPL_MFG_Warehouse_Pivot_Flag) = 1, do something , do something else)
knowing that your variable should start with equal sign (kind of optimization)

[anat]

i think so that is not possible,but we can do like

define flag in backend using inline 

test:

load * inline [

flag

1

];

so in UI use like

sum({<flag={=$(variable)}>}sal)