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

[paulyeo11]

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

[shilpan]

Try this:

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

[paulyeo11]

Hi Sir

Thank you very much . i try cannot work.

Paul

[paulyeo11]

Hi All

Can some one advise me how to solve this ?

Paul

[Miguel_Angel_Baeyens]

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.

[paulyeo11]

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>

[paulyeo11]

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