Date Dimension

[kaylaramsey2]

I'm having issues with my date dimension in Qlik View showing up too many times

Original Data Set

Date      Minutes

1/1/18          xxx

1/2/18          xxx

1/3/18          xxx

1/4/18          xxx

What I need the table to do is :

Date     Minutes

Jan          XXX

In my dimension I did (date(Date, 'MMM'))

My current table:

Date     Minutes

Jan          XXX

Jan          XXX

Jan          XXX

Jan          XXX

[trdandamudi]

I think it is because of the DateFormat. Make sure your SET DateFormat='MM/DD/YYYY';

[johnca]

Maybe try Date(MonthStart(Date), 'MMM')

HTH,

John

[sunny_talwar · Accepted solution]

Instead of Date() function, use Month() function

Month(Date)

It would be even better if you can do this in the script and create a new field

Month(Date) as Month

and then use Month as the dimension

[sunny_talwar]

Why not just the Month function

[MarcoWedel]

Date() is a formatting function that does not change the numerical part of your Date field values thus keeping distinct dimension values all sharing the same text representation.

[balabhaskarqlik]

May be this:

=Month(Date#(Date,'MMM')) as Date

[balabhaskarqlik]

=Date(Date#([Planned Completion Date],'DD-MMM-YY'),'MMM') as Date

[jmmolero]

Hi Kayla,

In your straight table, "Minutes" is a dimesion or a measure? What is the expression?