topic Re: Month to date in QlikView

Month to date

razvan_brais — Wed, 25 Nov 2020 16:16:04 GMT

Hy guys. What am I doing wrong in Month to date calculus? The result is 0 for this expression;

=Sum({<DATE={">=$(=Num(MonthStart(Max(GetFieldSelections(DATE)))))<=$(=Max(GetFieldSelections(DATE)))"}>} SALES)

sunny_talwar — Thu, 29 Sep 2016 11:35:48 GMT

Do you select multiple dates or just a single date? May be try this:

=Sum({<DATE={">=$(=Date(MonthStart(Max(DATE)), 'DateFieldFormatHere'))<=$(=Date(Max(DATE), 'DateFieldFormatHere'))"}>} SALES)

trdandamudi — Thu, 29 Sep 2016 11:36:11 GMT

Can you share a sample with expected output..

In the above expression you are using "Num" for the greater than date, Is the date is numeric ?

Anonymous — Thu, 29 Sep 2016 11:38:06 GMT

may be helpful for you?

Anil_Babu_Samineni — Thu, 29 Sep 2016 11:40:57 GMT

Would you be able to provide sample or try this too. I've added num function in the second date which you required

=Sum({<DATE={">=$(=Num(MonthStart(Max(GetFieldSelections(DATE)))))<=$(=num(Max(GetFieldSelections(DATE))))"}>} SALES)

razvan_brais — Thu, 29 Sep 2016 11:40:58 GMT

Thanks alot guys. It was the dateformat problem. I`m so happy when I see that I get answers so fast

Thank you again.