Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Table monthly

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

1 Solution

Accepted Solutions
shiveshsingh
Master
Master

May be this

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

View solution in original post

5 Replies
tripatirao
Creator II
Creator II

Please share what you  want calculate from this date field.

Is it monthname of the date .

Share some sample data

thevingo
Creator
Creator

Hi

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

shiveshsingh
Master
Master

May be this

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

soniasweety
Master
Master
Author

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

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

shiveshsingh
Master
Master

Can you share your app?