Set Analysis expression

[shaosiong]

Hi Qlik Heroes

I am having some trouble with writing my Qlik Set Analysis expression. Will appreciate some help on this.

Previously I have been loading my data with conditions in the script as below.

WHERE FIELD_ACCOUNT1 <> 'ABCD'
AND FIELD_ACCOUNT2  <>'XXX'
AND FIELD_ACCOUNT2  <> 'YYY'
AND FIELD_ACCOUNT2  <>'ZZZ'

Now I need to retain entire data loaded into my application but would like to create a chart with a set analysis expression of total sum of sales to capture the calculations based on the above conditions.

Previously it is simply with SUM(SALES) since the conditions have been applied in the loading script but now I need a set analysis. 

Many thanks in advance for your kind help!

Regards

Shao

[henrikalmen · Accepted solution]

sum({<FIELD_ACCOUNT1-={'ABCD'}, FIELD_ACCOUNT2-={'XXX', 'YYY', 'ZZZ'}>} SALES)