What is wrong in expression

[qlik4asif]

Hello Guys,

I have created a variable in front end as below

vAvailable_Stock ---> sum(Stock_A) + sum(Stock_B)

with no equal sign, because i want it dynamically with selections.

In front end i have created a KPI with below expression

Week(Max({<Sum_Orders={"<= $(vAvailable_Stock)"}>}Week_Start_End_Week_Count))

This should bring the week number, but is giving null.

I already checked with hard coded value as below and it is working.

Week(Max({<Sum_Orders={"<= 600000"}>}Week_Start_End_Week_Count))

Please suggest

Thanks

[qlik4asif]

Even i tried this

Week(Max({<Sum_Orders={"<= $(=vAvailable_Stock)"}>}Week_Start_End_Week_Count))

[qlik4asif]

The below expression worked

Week(Max({<Sum_Orders={"<= $(=$(vAvailable_Stock))"}>}Week_Start_End_Week_Count))