Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
RKULKARNI4
Contributor III
Contributor III

Variable set

Hello Team,

 I am setting the variables formula in different variable like ex :'VNetAmt=Amt',SImilar way i need to provide the where condition:

v1MonthLateAmount=Sum of vNetAmountIn Where vMonthsLate=1; 

Please let me know how it can be done.

Thanks in advance

Regards

RK

 

 

1 Reply
peachman
Contributor III
Contributor III

I'm not sure it is possible. A value is stored in a variable, you would have to build an expression for your criteria required in the variable that uses a variable, I've not explored storing lists in variables so not sure if it possible