This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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?
View solution in original post
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.....
The Date Function
Is there a way to show MonthStart as MMM-YYYY?
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
I think this calculated dimension will help get the expected output