Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I think it is because of the DateFormat. Make sure your SET DateFormat='MM/DD/YYYY';
Maybe try Date(MonthStart(Date), 'MMM')
HTH,
John
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
Why not just the Month function
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.
May be this:
=Month(Date#(Date,'MMM')) as Date
=Date(Date#([Planned Completion Date],'DD-MMM-YY'),'MMM') as Date
Hi Kayla,
In your straight table, "Minutes" is a dimesion or a measure? What is the expression?