Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

My Data for my chart is not grouping

I am new to QlikView, and I'm having a problem grouping my data.  I would appreciate anybody who can assist me.  I'm trying to group my data by month/year...and to drill into each individual day.   I load the data as follows...

Load

"Shift_date",

date(Shift_date,'YYYY-MM' ) as yrMonth,

..........

I add an new Chart and add the new group by Properties -> Dimensions -> Edit Group -> New .....and add Fields "yrMonth" and "Shift_date" as a Drill-down Group.

   When selecting all days for 2 months...say June and July...I expect to see 2 Bar charts for June and July and to drill into a bar (say June) and to view all individual days.   Instead it displays all days for both months.....Again, any help will be much appreciated. ...Thanks in advance

1 Solution

Accepted Solutions
Employee
Employee

Re: My Data for my chart is not grouping

You will need to use monthstart() to force all dates to the beginning of then month in addition to formatting the date.

4 Replies
Not applicable

Re: My Data for my chart is not grouping

Hi Gary,

Can you attach a sample? May be simpler/faster way to resolve issue.

Best,

Matt

Employee
Employee

Re: My Data for my chart is not grouping

You will need to use monthstart() to force all dates to the beginning of then month in addition to formatting the date.

Not applicable

Re: My Data for my chart is not grouping

Thank you so much.....it works perfectly

Not applicable

Re: My Data for my chart is not grouping

Matthew....thanks for you response too, but I wasn't sure what and how to attach

Community Browser