topic Date Dimension in QlikView

Date Dimension

kaylaramsey2 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Date Dimension

trdandamudi — Fri, 17 Aug 2018 17:47:46 GMT

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

Re: Date Dimension

johnca — Fri, 17 Aug 2018 18:23:57 GMT

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

HTH,

John

Re: Date Dimension

sunny_talwar — Fri, 17 Aug 2018 18:24:13 GMT

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

Re: Date Dimension

sunny_talwar — Fri, 17 Aug 2018 18:24:32 GMT

Why not just the Month function

Re: Date Dimension

MarcoWedel — Fri, 17 Aug 2018 20:17:22 GMT

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.

Re: Date Dimension

BalaBhaskar_Qlik — Sat, 18 Aug 2018 14:06:25 GMT

May be this:

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

Re: Date Dimension

BalaBhaskar_Qlik — Sat, 18 Aug 2018 14:06:42 GMT

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

Re: Date Dimension

jmmolero — Sat, 18 Aug 2018 14:51:49 GMT

Hi Kayla,

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