Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

izzatazfar8
New Contributor II

Calculate Month To date MTD

Hi, I have a problem to calculate Month To date MTD in my data. Is it my format in excel wrong or what? I will share the both file.
PAC Platform in excel is just a file to concatenate with the file named "book1" on field name only.

1 Solution

Accepted Solutions
rohitlohani
New Contributor III

Re: Calculate Month To date MTD

hi izzat azfar ,

try this expression to get ur desire result to calculate mtd ,

Sum({<OrderDate={">=$(=(MonthStart(Max(OrderDate))))<=$(=Max(OrderDate))"},Year=,Month=>} [ urfeild])

hope this will work ,

regards

rohit

3 Replies
luismadriz
Valued Contributor

Re: Calculate Month To date MTD

Hi Izzat,

What expression are you using to calculate MTD? Maybe you could start with something like this: Sum(IF([date]>=Monthstart(today()),gasdaily))

You may want to use a Master Calendar. If you want to create a master calendar based on your date field you may want to check this one I did a while ago: https://community.qlik.com/docs/DOC-19202

I hope this helps,

Cheers,

Luis

rohitlohani
New Contributor III

Re: Calculate Month To date MTD

hi izzat azfar ,

try this expression to get ur desire result to calculate mtd ,

Sum({<OrderDate={">=$(=(MonthStart(Max(OrderDate))))<=$(=Max(OrderDate))"},Year=,Month=>} [ urfeild])

hope this will work ,

regards

rohit

luismadriz
Valued Contributor

Re: Calculate Month To date MTD

Hi,

Just wondering to know how you went about this one,

Cheers,

Luis

PS. When applicable please mark the appropriate replies as Correct. This will help community members know which discussions have already been addressed and have a possible known solution. Please mark replies as Helpful if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as Helpful if you feel additional info is useful to others

Community Browser