topic Re: Cannot use script -= in QlikView

Cannot use script -=

Fri, 06 Nov 2015 08:11:18 GMT

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

swuehl — Fri, 06 Nov 2015 13:02:00 GMT

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?

alexandros17 — Fri, 06 Nov 2015 13:03:26 GMT

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

Anonymous — Fri, 06 Nov 2015 13:04:25 GMT

Try this:

=sum({<ID = {'A1'},[PRODUCT] -= {'UNIT-NON'}>} AMOUNT)/1000000)

Colin-Albert — Fri, 06 Nov 2015 13:04:44 GMT

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.