topic Set analysis in QlikView

Set analysis

Mon, 18 May 2015 11:27:27 GMT

Can anyone help to convert the below expression to set analysis?

and MTD for the selected month r date??

=sum(if(month(today(0))=month(Date),sales))

Re: Set analysis

sunny_talwar — Mon, 18 May 2015 12:11:17 GMT

Within the script

LOAD Date,

MonthName(Date) as MonthYear

Resident.....

Try this for sum of sales for the current month.

=Sum({<MonthYear = {"$(=MonthName(Today(0)))"}>} Sales)

Are you also looking to calculate MTD(Month to date)?

Best,

Sunny

Re: Set analysis

ToniKautto — Mon, 18 May 2015 12:14:52 GMT

Why do you want to convert it to a set expression?

I do not think your expression is perfect for a set expression. You should add a field in your data model that returns the Month(Date) value. If we assume this field has been added and if called 'MonthDate' a set expression could look something like...

=sum( {<MonthDate={"$(=month(today(0)))"}>} sales )

Re: Set analysis

Anonymous — Mon, 18 May 2015 18:37:03 GMT

Try this:

=sum({<Date={"=MonthStart(today(0))=MonthStart(Date)"} sales))