Set Expression of 'InMonthToDate'

atsushi_saijo — Mon, 05 May 2014 07:01:58 GMT

Dear Gurus,

I have used InMonToDate in current project, not least it allows Financial Year and standard Calendar Year easily switched by having start month. But if I needed to achieve this in set expression, how could I write it?

[Expression]

[in Set Analyses]

Date =

>=$(=MonthStart(Today(0),$(=-X)))

>=$(=MonthEnd(Today(0),$(=-X)))

Above is one thought to achieve InMonthToDate, but is there something like:

$(=InMonthToDate(....)) ?

I'd apprecaite for any feedback in advance.

[Additional Question 2.] is it the case, that I cannot write set analyses in multiple lines, but always need making it being single line?

Re: Set Expression of 'InMonthToDate'

tresB — Mon, 05 May 2014 07:17:51 GMT

InMonthToDate() returns true/false, hence you can't directly write like: Date={">$(=InMonthToDate())"}. May be you can try like: Date={">$(=If(InMonthToDate(), Date))"},,,, that is compare the date field.

To answer your second questtion: No, it's not necessarily so.

topic Re: Set Expression of 'InMonthToDate' in QlikView

Set Expression of 'InMonthToDate'

Re: Set Expression of 'InMonthToDate'