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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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