Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Set expression how can 1 exclude 2 condition ?

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

1 Solution

Accepted Solutions

Re: Set expression how can 1 exclude 2 condition ?

Try this.

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


Regards,

Kaushik Solanki

2 Replies

Re: Set expression how can 1 exclude 2 condition ?

Try this.

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


Regards,

Kaushik Solanki

paulyeo11
Valued Contributor II

Re: Set expression how can 1 exclude 2 condition ?

Hi Kaushik

Thank you very much. it work

Paul

Community Browser