Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
shilpan
Luminary Alumni
Luminary Alumni

Try this:

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

paulyeo11
Master
Master
Author

Hi Sir

Thank you very much . i try cannot work.

Paul

paulyeo11
Master
Master
Author

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
Master
Master
Author

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
Master
Master
Author

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