topic Re: Less than in Set Analysis in QlikView

Less than in Set Analysis

Tue, 08 Apr 2014 07:48:31 GMT

Hi All

I cant find the right syntax for less than in a set analysis. I am having a variable that returns the nr for the open month or max selected month. I want to put this into a set analysis for MonthNr but I cant find the right syntax.

sum({<MonthNr????{$(vMonthNr)}>}Cost)

I am happy for any help.

//Fredrik

Re: Less than in Set Analysis

Anonymous — Tue, 08 Apr 2014 08:11:09 GMT

Try..

sum({<MonthNr={"<$(=num(vMonthNr))"}>} Cost )

Re: Less than in Set Analysis

MK_QSL — Tue, 08 Apr 2014 08:40:01 GMT

=SUM({$<MonthNr= {'<$(=NUM(vMonthNr))'}>}Cost )

Re: Less than in Set Analysis

Tue, 08 Apr 2014 08:43:52 GMT

Thanks for your reply. It should work fine. I found the right syntax after posting this on the thread. I wrote it like this.

MonthNr={"<=$(vMonthNr)"}

And that worked fine.

Re: Less than in Set Analysis

Tue, 08 Apr 2014 08:43:57 GMT

Thanks for your reply. It should work fine. I found the right syntax after posting this on the thread. I wrote it like this.

MonthNr={"<=$(vMonthNr)"}

And that worked fine.