topic Set expression how can 1 exclude 2 condition ? in QlikView

Set expression how can 1 exclude 2 condition ?

paulyeo11 — Tue, 27 Feb 2018 07:39:42 GMT

HI All

Below expression work fine :-

Sum({<year={">=2015"},sub_seg={"02"}>} sales)

I want to modify the above expression with exclude seg=02 , it work fine :-

Sum({<year={">=2015"},sub_seg|={"02"}>} sales)

Now i encounter problem , when i try exclude one more seg=01 :-

Sum({<year={">=2015"},sub_seg|={"02"},sub_seg|={"01"}>} sales)

Can some one advise me where go wrong ?

Paul Yeo

kaushiknsolanki — Tue, 27 Feb 2018 07:42:18 GMT

Try this.

Sum({<year={">=2015"},sub_seg-={"02","01"}>} sales)

Regards,

Kaushik Solanki

paulyeo11 — Tue, 27 Feb 2018 08:13:21 GMT

Hi Kaushik

Thank you very much. it work

Paul