topic Re: How to group by Calculated dimention? in QlikView https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486337#M181699 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached file for solution</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 27 Sep 2013 10:13:04 GMT jagan 2013-09-27T10:13:04Z How to group by Calculated dimention? https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486335#M181697 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>Recently I face a Problem...</P><P></P><P>I have some VIPs, when VipCode is a dimention, I can use count(distinct DocumentNumber) to calculate their shopping frequency on a Straight table</P><P>eg:</P><P>vipcode |&nbsp; Shopping Freq.</P><P>a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 2</P><P>b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 2</P><P>c&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 4</P><P>d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 5</P><P>e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 6</P><P>f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp;&nbsp; 0</P><P></P><P>Is there any approach to build another Straight table</P><P>group by the Shopping Frequency?</P><P></P><P>eg:</P><P>shopping freq.| no of Vip</P><P>0&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P>2&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 2</P><P>4&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P>5&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P>6&nbsp;&nbsp;&nbsp;&nbsp; |&nbsp; 1</P><P></P><P>I originally Thought it's only a memory demanding process(recursive)... but now it seems impossible...</P><P>Anyone can help?</P><P></P><P>Many Thanks!</P></BODY></HTML> Fri, 27 Sep 2013 09:00:08 GMT https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486335#M181697 2013-09-27T09:00:08Z Re: How to group by Calculated dimention? https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486336#M181698 <HTML><HEAD></HEAD><BODY><P>May be like attached sample?</P></BODY></HTML> Fri, 27 Sep 2013 10:04:26 GMT https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486336#M181698 tresB 2013-09-27T10:04:26Z Re: How to group by Calculated dimention? https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486337#M181699 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached file for solution</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Fri, 27 Sep 2013 10:13:04 GMT https://community.qlik.com/t5/QlikView/How-to-group-by-Calculated-dimention/m-p/486337#M181699 jagan 2013-09-27T10:13:04Z