Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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

My QVW

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

What exactly you want to do here?

paulyeo11
Valued Contributor II

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

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>

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

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

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

Hi Manish

Sorry for the wrong posting.

Paul Yeo

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

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 !!!

Community Browser