Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Script:
pick(WildMatch(currency,'XX'),'0.099') as Value,
Later, when I want use that column a do some calculation - a see 0.099 but qlik change number to 99.
I try num:
num(pick(WildMatch(currency,'XX'),'0.099')), num# etc
Hi, have you tried without the simple quotes in number?: pick(WildMatch(currency,'XX'),0.099) as Value,