Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

autoCalendar.YearMonth

Hi,

I am looking to use autoCalendar.YearMonth filter in an expression but it won't recognize 'Feb-2017'. It gives it in this format when i use it as a dimension in my charts.

qlik.JPG

Count(DISTINCT {<status={'Current'}, [RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID) /

Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {'Feb-2017'}>} ID)

Anyone know the correct format?

Regards

Finbar

15 Replies
passionate
Specialist
Specialist

Convert your date in number i.e. NUM(Date) and use this numeric value in expression.

Using numeric value for date in expression is easier to use

Anonymous
Not applicable
Author

Hi sasiparupudi1,

Tried that and doesn't work.

Finbar

Anonymous
Not applicable
Author

Also does not work

Anonymous
Not applicable
Author

There is something up with trying to reference the month... measure 1 and 2 do not work!

sasiparupudi1
Master III
Master III

Pl Try

=Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {"$(=Date(MonthStart(Today()),'YYYY-MMM'))"}>} ID)

Anonymous
Not applicable
Author

Hi all,

Found the solution! I was using single quotations, only works with double quotations!! Its always something easy!! 

Count(DISTINCT {<status={'Current'}, [RENDATE.autoCalendar.YearMonth] = {"Feb-2017"}>} ID) /

Count(DISTINCT {<[RENDATE.autoCalendar.YearMonth] = {"Feb-2017"}>} ID)