Set Analysis expression

shaosiong — Fri, 03 Mar 2023 07:38:49 GMT

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

Re: Set Analysis expression

henrikalmen — Fri, 03 Mar 2023 07:48:38 GMT

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

topic Re: Set Analysis expression in App Development

Set Analysis expression

Re: Set Analysis expression