Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

=num(Sum({$< Month_n ={"1"}>} sales/1000)/Rate) How to convert to SET expression

Hi All


I have this expression work fine :-


=num(Sum({$< Month_n  ={"1"}>} sales/1000)/Rate)


Can some SET expert here help me convert to using SET expression. So that i dont need to use the additional field on Month_n


Remark :- Below expression is YTD work fine :-


=num(SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales/1000))



Paul

  

6 Replies
paulyeo11
Master
Master
Author

My QVW

MK_QSL
MVP
MVP

What exactly you want to do here?

paulyeo11
Master
Master
Author

I want to learn how to use SET expression , so that I don’t have to create month_n field. As in some of the input field like sales target , it does not have month_n field , so I can only use SET expression , as I aware SET expression don’t need month_n

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +65 9326 1804

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

MK_QSL
MVP
MVP

To be honest.. I haven't understood yet.

Also, you wrote

I have try your recomeended expression , but it display null.

I don't know, what I have recommended !!!

paulyeo11
Master
Master
Author

Hi Manish

Sorry for the wrong posting.

Paul Yeo

MK_QSL
MVP
MVP

I can still try to help you.. Let me know exactly what you want?

Looks like, you are posting more than one post at a time and mixing your replies !!!