Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
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