Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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


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

6 Replies
shilpan9166
Contributor II

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

Try this:

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

paulyeo11
Valued Contributor II

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

Hi Sir

Thank you very much . i try cannot work.

Paul

paulyeo11
Valued Contributor II

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

Hi All

Can some one advise me how to solve this ?

Paul

MVP
MVP

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

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
Valued Contributor II

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

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
Valued Contributor II

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

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

Community Browser