Set Analysis Variable Parameter

[coolguy123]

I have created a variable 

Let v_test = if($(1) <$(2 ), ‘actual’, if($(1)=$(2), ‘budget’, ‘’))

in script is i create a measure with set analysis it show error set modifier

$(v_test(Sum({$<Region ={‘South’}, Year = {2010}>} Sales), Sum({$<Region ={‘South’}, Year = {2011}>} Sales)))

this give me error why?

[juraj_misina]

I think the problem is in the comma within the set analysis. Comma is a parameter separator and dollar sign expansion cannot handle a situation where parameter contains a comma. See here for details and workarounds: https://community.qlik.com/t5/Documents/Variables-with-Parameters-when-the-value-has-a-comma-quot-qu...

Hope this helps

Juraj