topic Re: SET expression add new condition sub_seg={"02"} not working in QlikView

SET expression add new condition sub_seg={"02"} not working

paulyeo11 — Wed, 21 Feb 2018 04:41:26 GMT

Hi All

Below expression work fine :-

Sum({<year={2016}, COMPANY = {"=Rank(Sum({<year = {2016}>} sales)) <= 5"}>} sales)

I try to add new condition sub_seg={"02"} to above expression , it does not work :-

Sum({$< SOURCE ={"TDSS"},sub_seg={"02"},COMPANY = {"=Rank(Sum({<year = {2018}>} sales)) <= 5"}>} sales/1000)

Hopw some one can share wifh me why ?

Paul

Re: SET expression add new condition sub_seg={"02"} not working

shilpan — Wed, 21 Feb 2018 04:47:34 GMT

Try this:

Sum({$< SOURCE ={'TDSS'},sub_seg={02},COMPANY = {"=Rank(Sum({<year = {2018}>} sales)) <= 5"}>} sales/1000)

Re: SET expression add new condition sub_seg={"02"} not working

paulyeo11 — Wed, 21 Feb 2018 04:51:20 GMT

Hi Sir

Thank you very much . i try cannot work.

Paul

Re: SET expression add new condition sub_seg={"02"} not working

paulyeo11 — Wed, 21 Feb 2018 06:40:48 GMT

Hi All

Can some one advise me how to solve this ?

Paul

Re: SET expression add new condition sub_seg={"02"} not working

Miguel_Angel_Baeyens — Wed, 21 Feb 2018 07:53:53 GMT

It works on a text object, display different results depending on whether the field is used in the set analysis or not.

It does not in the chart and with such (rather complex) data model (are you using those synthetic keys on purpose?) and the variable as dimension, I'm afraid I cannot give a better explanation without further hints.

Re: SET expression add new condition sub_seg={"02"} not working

paulyeo11 — Wed, 21 Feb 2018 07:58:32 GMT

Hi Miguel

Why I cannot view your post from forum ? I get error msg when I click the link from email .

When I go to the my post , I cannot see your reply only can see from email .

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

www.tdstech.com<http://www.tdstech.com>

Re: SET expression add new condition sub_seg={"02"} not working

paulyeo11 — Wed, 21 Feb 2018 08:06:56 GMT

Hi Miguel

Yes I am using syn key on to make my data model look neat.

Any way thank you very much for your help.

Paul