Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
WE ARE LISTENING! New Navigation for Qlik Community, Sept. 26: TELL ME MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ronman10
Creator
Creator

Selecting Specific Months

Hi Guys,

I am looking for an expression to select the first 5 months of a particular year, say 2017, in order to show year to date sales. Please let me know how I can get this done.

Regards,

Rony

6 Replies
sunny_talwar

May be this

Sum({<DateField = {">=01/01/2017<=05/01/2017"}>}Measure)

nitin_01
Creator
Creator

or may be this if it needs to be dynamic :

vFirst=YearStart('DateField',0,1);

vFifth=YearStart('DateField',0,5);

Regards,

Nitin G.

ronman10
Creator
Creator
Author

Hi Sunny and Nitin,

I am still not able to get this. Let me check where I am going wrong and get back.

Thanks,

Rony

sunny_talwar

What is your datefield format?

sunny_talwar

May be this can help

Dates in Set Analysis

ronman10
Creator
Creator
Author

It is as you mentioned above. 01/01/2017<=05/01/2017.

Thanks Sunny. I will check this out.