Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Please below my script:
if(ID = 'A1', sum({<[PRODUCT] -= {'UNIT-NON'}>} AMOUNT)/1000000)
why field amount for font colour not brown? what's wrong in my script?
Thanks
Probably nothing is wrong. The syntax highlighter is not correctly showing some syntax as incorrect, when it's correct in fact.
Does your expression evaluate in the chart?
It shows as error but it works .... you can use the equivalent expression:
if(ID = 'A1', sum({<[PRODUCT] = {'*'} - {'UNIT-NON'}>} AMOUNT)/1000000)
let me know
Try this:
=sum({<ID = {'A1'},[PRODUCT] -= {'UNIT-NON'}>} AMOUNT)/1000000)
Which version & SR of QlikView are you using?
Versions prior to v11.2 SR12 will show everything after a -= underlined in red although the syntax may be correct.