Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist
Specialist

Date Dimension Aggr(max)) Repeating

I thought I had figured out the syntax for my date dimension because it looks right when one DEFECT_ID is selected but when multiple are selected, the date is repeating instead of showing aggregated by month. Can someone please help?

=aggr(max( date(DEFECT_STATUS_START_DATE,'MMM-YYYY')),DEFECT_ID)

2018-09-17_7-50-20.jpg

1 Solution

Accepted Solutions
stigchel
Partner
Partner

Dimension

=aggr(max( date(Monthstart(DEFECT_STATUS_START_DATE),'MMM-YYYY')),DEFECT_ID)

ScrAggrMonthstart.png

View solution in original post

6 Replies
stigchel
Partner
Partner

The function

date(DEFECT_STATUS_START_DATE,'MMM-YYYY')

Only formats the date. The date is a dual where the number part will still reflect each individual date. To have a single date per month you can use MonthStart(Date.....

stigchel
Partner
Partner

cbaqir
Specialist
Specialist
Author

Is there a way to show MonthStart as MMM-YYYY?

stigchel
Partner
Partner

Sure, should have turned that around myself already, so just wrap the formatting date function around the monthstart function instead of the other way around

YoussefBelloum
Champion
Champion

Hi,

I think this calculated dimension will help get the expected output

=Month(DEFECT_STATUS_START_DATE)&Year(DEFECT_STATUS_START_DATE)


stigchel
Partner
Partner

Dimension

=aggr(max( date(Monthstart(DEFECT_STATUS_START_DATE),'MMM-YYYY')),DEFECT_ID)

ScrAggrMonthstart.png

View solution in original post