Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ronman10
New Contributor III

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

Re: Selecting Specific Months

May be this

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

nitin_01
Contributor

Re: Selecting Specific Months

or may be this if it needs to be dynamic :

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

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

Regards,

Nitin G.

ronman10
New Contributor III

Re: Selecting Specific Months

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

Re: Selecting Specific Months

What is your datefield format?

Re: Selecting Specific Months

May be this can help

Dates in Set Analysis

ronman10
New Contributor III

Re: Selecting Specific Months

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

Thanks Sunny. I will check this out.

Community Browser