topic Syntax errore in QlikView

Syntax errore

Wed, 09 Dec 2015 02:00:03 GMT

Could u please correct syntax errore in set analysis

tamilarasu — Wed, 09 Dec 2015 02:04:32 GMT

Hi,

Correct syntax should be,

=sum({$<[Year]={"$(=max(Year))"}>}[Order Quantity])

=sum({$<[Year]={"$(=max(Year)-1)"}>}[Order Quantity])

Check the attachment and let me know.

sunny_talwar — Wed, 09 Dec 2015 02:10:05 GMT

Didn't check what Tamil have (may be I am repeating), but just thought I will also share my solution

=Sum({$<[Year]={'$(=max(Year))'}>}[Order Quantity])

=Sum({$<[Year]={'$(=max(Year)-1)'}>}[Order Quantity])