2 Replies Latest reply: Feb 27, 2018 3:13 AM by Yeo Poh sai RSS

    Set expression how can 1 exclude 2 condition ?

    Yeo Poh sai

      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