Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
didierodayo
Partner - Creator III
Partner - Creator III

help explaining expression

Could I please have an explanation of the query below? I am trying to understand what the straight table expression is calculating

Sum({$<TICKET={ '*' } - { ''  }>} VAT)

regards

D

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Perhaps this intends to sum all VATs considering all TICKETs excluding null. However, Sum({$<TICKET={ '*' } >} VAT) itself should give the same output, because '*' itself doesn't include null. If your TICKET field has some values which are not really null but blank, it might give a different output (which is possibly expected) I presume.

View solution in original post

1 Reply
tresesco
MVP
MVP

Perhaps this intends to sum all VATs considering all TICKETs excluding null. However, Sum({$<TICKET={ '*' } >} VAT) itself should give the same output, because '*' itself doesn't include null. If your TICKET field has some values which are not really null but blank, it might give a different output (which is possibly expected) I presume.