topic Re: Issue with date? in QlikView

Issue with date?

Anonymous — Fri, 06 Nov 2015 08:06:55 GMT

I have dates in text format . Field name is ProjectMonth with values starting Dec-2015 till Nov-2015.

I want to plot a graph that shows the sum of efforts for the months less than the current month. Hence when I try to put an expression as monthname(date#(ProjectMonth,'MM-YYYY'))<=monthname(today()) to calculate the effort for the months less than the current month I am not getting values..Cell values appear blank.

can you anybody please let me know what is going wrong in my expression?

thanks

Re: Issue with date?

tamilarasu — Fri, 06 Nov 2015 08:13:36 GMT

Hi Sanjyot,

Use proper date function. It should be

=monthname(date#(ProjectMonth,'MMM-YYYY'))<=monthname(today())

Re: Issue with date?

Anonymous — Fri, 06 Nov 2015 08:16:21 GMT

You can use sth like this:

=sum({<ProjectMonth={'>=$(=date(monthname(ProjectMonth),'MM-YYYY')'<=date(monthname(today()),'MM-YYYY') }>} Effort)

Re: Issue with date?

Anonymous — Fri, 06 Nov 2015 08:20:12 GMT

or simply:

=sum({<ProjectMonth={'<=date(monthname(today()),'MM-YYYY') }>} Effort)