topic Grouping based on Date and event in QlikView https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963366#M962856 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><EM> have below data set and need to create a table using it. The problem i have is how to group it based on event</EM></P></BODY></HTML> Tue, 13 Oct 2015 06:26:56 GMT anuradhaa 2015-10-13T06:26:56Z Grouping based on Date and event https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963366#M962856 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P><EM> have below data set and need to create a table using it. The problem i have is how to group it based on event</EM></P></BODY></HTML> Tue, 13 Oct 2015 06:26:56 GMT https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963366#M962856 anuradhaa 2015-10-13T06:26:56Z Re: Grouping based on Date and event https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963367#M962858 <HTML><HEAD></HEAD><BODY><P>Try with generic load as suggested here: <A href="https://community.qlik.com/qlik-blogpost/3629">The Generic Load</A></P></BODY></HTML> Tue, 13 Oct 2015 06:37:32 GMT https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963367#M962858 tresB 2015-10-13T06:37:32Z Re: Grouping based on Date and event https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963368#M962860 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>you can try with cross table also. Then you can create the pivot chart.</P><P>Check the attach<SPAN style="font-size: 13.3333px;">ment may be helps</SPAN></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101818_Capture.JPG" style="height: 145px; width: 620px;" /></P></BODY></HTML> Tue, 13 Oct 2015 06:55:40 GMT https://community.qlik.com/t5/QlikView/Grouping-based-on-Date-and-event/m-p/963368#M962860 settu_periasamy 2015-10-13T06:55:40Z