Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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