topic Re: Re: need help?? in QlikView

need help??

paulwalker — Wed, 08 Oct 2014 15:01:56 GMT

Hi Community,

how to calculate MTD and YTD

MTD:

=Sum({<[Posting Date]={'>=$(=MonthStart(Today()))<=$(=Today())'}>} CLE_Amount)

i am using this expression.. but unable to get values..

Please anyone can help me.....

alexandros17 — Wed, 08 Oct 2014 15:08:41 GMT

Sum({<[Posting Date]={'$(>=MonthStart(Today())<=Today())'}>} CLE_Amount)

the $(= ... must be applied to the whole sub expression

let me know

antoniotiman — Wed, 08 Oct 2014 15:12:02 GMT

Hi Paul,

format of Posting Date is DD-MM-YYYY, but in script your DateFormat is D/M/YYYY

You can try

....$(=Date(MonthStart(Today()),'DD-MM-YYYY')))

also in $(=Today())

Regards,
Antonio

paulwalker — Wed, 08 Oct 2014 15:33:01 GMT

Hi ,

Still i am unable to get values...

jyothish8807 — Wed, 08 Oct 2014 15:40:34 GMT

Hi Paul,

try like this:

SUM({<Date = , Month =, Quarter = , Date = {">=$(=MonthStart(Today()))<=$(=Today())"}>}Sales)

will give you Total Sales for Current Month to Date

SUM({<Date = , Month =, Quarter = , Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Sales)

will give you Total Sales For Current Year to Date

Regards

antoniotiman — Wed, 08 Oct 2014 15:43:39 GMT

See Attachment

maxgro — Wed, 08 Oct 2014 19:41:11 GMT

it seems you have different format for the dates, in dimension and in set analysis expression

try with

=Sum({<[Posting Date]={">=$(=date(MonthStart(Today()),'MM-DD-YYYY'))<=$(=date(Today(),'MM-DD-YYYY'))"}>} CLE_Amount)