topic summary by group in QlikView https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631190#M231645 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 7.5pt; background: white;"><SPAN style="font-size: 8.5pt; font-family: 'Arial','sans-serif'; color: #676767;">​</SPAN><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">In Qliview, we can create a group, like date group to include Date, Week, Month, Quarter, and Year. Then, the group can be used for the X-Axis in chart. It is easily to switch data scale.&nbsp; When we do the summary by group like below </SPAN></P><P style="margin: 0 0 7.5pt; background-color: white;"><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">Count (TOTAL &lt;GROUP&gt; DISTINCT VISIT_KEY)</SPAN></P><P style="margin: 0 0 7.5pt; background-color: white;"><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">The computation will not work, if the group replaced by the data field, like month, we can get total for each dimension level. Anyone has idea how to resolve this issue?</SPAN></P></BODY></HTML> Wed, 28 May 2014 14:10:16 GMT 2014-05-28T14:10:16Z summary by group https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631190#M231645 <HTML><HEAD></HEAD><BODY><P style="margin-bottom: 7.5pt; background: white;"><SPAN style="font-size: 8.5pt; font-family: 'Arial','sans-serif'; color: #676767;">​</SPAN><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">In Qliview, we can create a group, like date group to include Date, Week, Month, Quarter, and Year. Then, the group can be used for the X-Axis in chart. It is easily to switch data scale.&nbsp; When we do the summary by group like below </SPAN></P><P style="margin: 0 0 7.5pt; background-color: white;"><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">Count (TOTAL &lt;GROUP&gt; DISTINCT VISIT_KEY)</SPAN></P><P style="margin: 0 0 7.5pt; background-color: white;"><SPAN style="font-size: 8.5pt; font-family: 'Verdana','sans-serif'; color: #676767;">The computation will not work, if the group replaced by the data field, like month, we can get total for each dimension level. Anyone has idea how to resolve this issue?</SPAN></P></BODY></HTML> Wed, 28 May 2014 14:10:16 GMT https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631190#M231645 2014-05-28T14:10:16Z Re: summary by group https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631191#M231646 <HTML><HEAD></HEAD><BODY><P>try here</P><P></P><P><A href="https://community.qlik.com/message/387598">cyclic dimension in an expression - using GetCurrentField ?</A></P></BODY></HTML> Wed, 28 May 2014 14:37:09 GMT https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631191#M231646 maxgro 2014-05-28T14:37:09Z Re: summary by group https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631192#M231647 <HTML><HEAD></HEAD><BODY><P>Massimo, Thanks. It works</P></BODY></HTML> Wed, 28 May 2014 15:54:27 GMT https://community.qlik.com/t5/QlikView/summary-by-group/m-p/631192#M231647 2014-05-28T15:54:27Z