Monthstart of Every Month to Max Date of Current Month Comparison

[#1]

Hi All

I am a newbie in Qlikview and this is my first Post in the Community.

I am trying something like this.

Is this possible.

I am tring with Monthstart Function but not getting desired result.

Regards

Eric

[ecolomer]

I do not know if I understand correctly

What you mean is you want to get for each month since the beginning of the month until the day (number) of the current month?

Something like that?

[ecolomer]

If you want formar dd-mmm-yyyy

[#4]

Dear Sir

Thanks for the Reply.

I have Attached my Requirement.

PFA.

Regards

Eric

[ecolomer · Accepted solution]

This?

[#6]

Sir

This is Perfect.

But Is there a way with Set Analysis.

I don't want to use Makedate() Function.

This Solution Works with Current Year.

If I have to show data forPast Years than...........???

Regards

Eric

[#7]

Sir

I need a Solution with Set Analysis.

Regards

Eric

[jonathandienst]

Set analysis is for filtering data and your post did not ask how to filter -- you just asked about how to construct dates and the answer to your question used makedate.

If you want to filter based on these dates, I suggest that you create a new post, showing what it is you want to filter, whether its in the back end or front - and if in front, in what sort of object (text box table dimension, table expression etc). A qvw with data (or a representative sample) would also help to better understand your requirements.