topic Re: Help me with the error please in QlikView

Help me with the error please

Thu, 19 Sep 2013 23:05:26 GMT

Sum({<Date >=$(vCurrentMonthstart) and Date <= $(vCurrentMonthend)>},[GL Post Amount])

I am getting error with the above expression.Please help me.

Thanks in advance

Re: Help me with the error please

MayilVahanan — Thu, 19 Sep 2013 23:09:07 GMT

Try like this

Sum({<Date = {">=$(=Date(vCurrentMonthstart)) <= $(=Date(vCurrentMonthend))"}>} [GL Post Amount])

Note:

Please check the date format. Both must be in same format

For ex: MMDDYYYY means, both must be in MMDDYYYY format

Re: Help me with the error please

jagan — Fri, 20 Sep 2013 02:20:09 GMT

Hi,

Try this expression

=Sum({<Date={'>=$(=vCurrentMonthstart) <= $(=vCurrentMonthend)'} >} [GL Post Amount])

Using this expression still you did not get the results then check the date format in variables and Date Dimension, the format should be same for the variables and Date dimension values.

Regards,

Jagan.