topic Re: Using variable in set analysis in App Development

Using variable in set analysis

risabhroy_03 — Mon, 21 Feb 2022 09:54:33 GMT

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},

Re: Using variable in set analysis

ali_hijazi — Mon, 21 Feb 2022 10:35:17 GMT

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)

Re: Using variable in set analysis

anat — Mon, 21 Feb 2022 10:15:33 GMT

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

define flag in backend using inline

test:

load * inline [

flag

];

so in UI use like

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