Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
vijetas42
Specialist
Specialist

Set Analysis Expression

Hi All,

Can any body explain me what is the meaning of below expression.means,how it works

=SUM({$<[Year]={'2015'}>-<C1={'Blocked'}>-<D1={'Blocked'}>+

<[Cust Id={'43524'}>} [Sales Vol])

Regards,

Vijeta

1 Reply
maxgro
MVP
MVP

I think

sum of sales vol for year 2015, excluding c1 blocked, excluding d1 blocked, adding cust id 43524

but there is a missing ] after Cust Id