topic Re: monthstart to today in QlikView

monthstart to today

Fri, 04 Jan 2013 19:54:00 GMT

I am trying to caluculate or populate dates from month start to today...I am using following code....

Order_date = {">=$(=monthstart(today())<=$(=today())"}

but I am unable to populate....can anyone please correct me.....

Re: monthstart to today

Anonymous — Fri, 04 Jan 2013 20:34:23 GMT

447,

It will be
= {"$(='>=' & date(monthstart(today())) & '<=' & date(today()))"}

(count my open/close parenthesis)

Regards,

Michael

Re: monthstart to today

Fri, 04 Jan 2013 20:42:03 GMT

Thankyou, its working great....but if I want for different dates its not working.....for example I am selecting month as dec and year as 2012.....I want it to populate from dec 1st to today...depending on whatever month they selected...can you please help me with this......

Re: monthstart to today

Fri, 04 Jan 2013 20:47:41 GMT

I am having day month and year fields for order_date.....

Re: monthstart to today

Anonymous — Fri, 04 Jan 2013 21:00:36 GMT

If you wabt to get data from the start of the selected month to the day nbumber of the selected month equal to the current date, try this:

= {"$(='>=' & date(min(order_date)) & '<=' & date(makedate(year,month,day(today()))))"}

(assumong your month field is dual and has a numeric value)

Regards,

Michael

Re: monthstart to today

Fri, 04 Jan 2013 21:19:23 GMT

When I selected Dec I am getting dates for Dec but if no selections are made can I keep default to MTD to today......as you given in first expression......

Re: monthstart to today

Anonymous — Fri, 04 Jan 2013 21:26:25 GMT

The simplest way is to use conditional expression, something like this:

if(GetSelectedCount(month)=0,

<expression with = {"$(='>=' & date(monthstart(today())) & '<=' & date(today()))"}>,

<expression with = {"$(='>=' & date(min(order_date)) & '<=' & date(makedate(year,month,day(today()))))"}>)

There could be a more elegant solution, I'll try to get back to it.

Regards,

Michael