topic Re: Table monthly in QlikView

Table monthly

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

Hi all,

I want to count the numbers MTD on strightable

I have a datefield like

Num(Floor(Createdate)) as createDateNum,

how to get MTD for this ? how to write the expression for this?

Thanks

sony

Re: Table monthly

tripatirao — Tue, 27 Mar 2018 06:44:08 GMT

Please share what you want calculate from this date field.

Is it monthname of the date .

Share some sample data

Re: Table monthly

thevingo — Tue, 27 Mar 2018 06:47:42 GMT

Try this, if you want to calculate MTD for Sales, Sum({<createDateNum={">=$(=Num(MonthStart(Max(createDateNum))))<=$(=Max(createDateNum))"}>} Sales)

Also you can refer to

YTQ, QTD, MTD and WTD

Re: Table monthly

shiveshsingh — Tue, 27 Mar 2018 07:51:20 GMT

May be this

sum({<createDateNum = {">=$(num(monthstart(max(createDateNum))))<=$(=max(createDateNum) )"}>}Quantity)

Re: Table monthly

soniasweety — Tue, 27 Mar 2018 09:04:35 GMT

am using same but I am getting the result jan-05-2018

but MTD means max month data should come right? means march?

Re: Table monthly

shiveshsingh — Tue, 27 Mar 2018 09:12:23 GMT

Can you share your app?