Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

hammermill21
Contributor II

Month to Date

Hello everyone,

I'm working on this app and I have been trying different ways to get Month to Date and nothing I do seems to be working. Can anyone give some ideas?

Thanks

I've attached the QVF file.

10 Replies

Re: Month to Date

Which object are we talking about? What is the expected output?

hammermill21
Contributor II

Re: Month to Date

I forgot the details Sunny! Sorry about that.

As you can see there is a filter I added that currently says "Error", that is where I was trying to add the "month to date" selection so that the Table underneath would filter the data for that date range only.  "Dated Passed" is the date I am going by. So I need all the Units to filter by the Dated Passed based on the month to date. Make sense?

Re: Month to Date

You need this information in a filter object or a KPI object? Right now you are using a filter object with a dimension... is that what the goal is?

hammermill21
Contributor II

Re: Month to Date

Yes that's my goal.

Re: Month to Date

In your Application, There is no field Called SALES. What does the field name instead of SALES

Life is so rich, and we need to respect to the life !!!
hammermill21
Contributor II

Re: Month to Date

Hey Anil,

i'm sorry I don't understand what you are asking?

Re: Month to Date

Are you talking about this?

Capture.PNG

And, Yes i've read reply to sunny as well. Here, You are saying one Calculation showing error. But, I am not gone thru anything which is error.

Life is so rich, and we need to respect to the life !!!
hammermill21
Contributor II

Re: Month to Date

Oh I see, I was messing with it but it should be Units not Sales.

Re: Month to Date

But, When i try simple measure like Sum(Unit) It is not giving any value.

Life is so rich, and we need to respect to the life !!!
Community Browser