topic Re: How to create group Articles for SubTotal in QlikView https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303369#M112246 <HTML><HEAD></HEAD><BODY><P> Hi. </P><P></P><P>What is AAAA, BBBB, CCCC and DDDD?</P><P>Different Underfamilies? </P><P></P><P>//Robert</P></BODY></HTML> Wed, 22 Feb 2012 07:56:10 GMT RSvebeck 2012-02-22T07:56:10Z How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303365#M112242 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have the fiels follows : Articles - UnderFamily - Family.</P><P></P><P>Example : CodeArticles(0000A)- CodeUnderFamily(AAAA)- CodeFamily(AAAAB)</P><P></P><P>I would like to get this results :</P><P></P><P></P><P><IMG alt="Crosstab --SubTotal.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/11494_Crosstab+--SubTotal.png" /></P><P></P><P>If I create field like : 'CodeArticles&amp; ' ' &amp;CodeUnderFamily&amp; ' '&amp;CodeFamily do I obtain the result like the picture ?</P><P></P><P>Thanks for your help.</P></BODY></HTML> Tue, 21 Feb 2012 10:29:54 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303365#M112242 2012-02-21T10:29:54Z Re: How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303366#M112243 <HTML><HEAD></HEAD><BODY><P> Hi.Perhaps this will help you. See attached. //Robert</P></BODY></HTML> Tue, 21 Feb 2012 13:23:51 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303366#M112243 RSvebeck 2012-02-21T13:23:51Z How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303367#M112244 <HTML><HEAD></HEAD><BODY><P> Thanks a lot . It try like that and it works very well !!</P></BODY></HTML> Tue, 21 Feb 2012 15:31:37 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303367#M112244 2012-02-21T15:31:37Z How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303368#M112245 <HTML><HEAD></HEAD><BODY><P> Could I have an example with Switch case.</P><P></P><P>Example:</P><P></P><P>IF AAAA =&gt; GROUP 1</P><P>IF BBBB =&gt; GROUP 2</P><P>IF CCCC =&gt; GROUP 3</P><P>IF DDDD =&gt; GROUP 4</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 21 Feb 2012 16:54:57 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303368#M112245 2012-02-21T16:54:57Z Re: How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303369#M112246 <HTML><HEAD></HEAD><BODY><P> Hi. </P><P></P><P>What is AAAA, BBBB, CCCC and DDDD?</P><P>Different Underfamilies? </P><P></P><P>//Robert</P></BODY></HTML> Wed, 22 Feb 2012 07:56:10 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303369#M112246 RSvebeck 2012-02-22T07:56:10Z Re: How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303370#M112247 <HTML><HEAD></HEAD><BODY><P> Sorry, </P><P></P><P>AAAA, BBBB, CCCC and DDDD are the underFamilies.</P><P></P><P>Like:</P><P>CASE UnderFamilies</P><P>when 'AAAA' then 'GROUP1'</P><P>when 'BBBB' then 'GROUP1'</P><P>when 'CCCC' then 'GROUP2'</P><P>when 'DDDD' then 'GROUP2'</P><P>End</P><P></P><P>Thanks..</P></BODY></HTML> Wed, 22 Feb 2012 08:18:06 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303370#M112247 2012-02-22T08:18:06Z Re: How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303371#M112248 <HTML><HEAD></HEAD><BODY><P> Do you mean like this?</P></BODY></HTML> Wed, 22 Feb 2012 10:28:28 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303371#M112248 RSvebeck 2012-02-22T10:28:28Z How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303372#M112249 <HTML><HEAD></HEAD><BODY><P> Yes.. thanks.</P><P>It was just to have an example with switch case...</P></BODY></HTML> Wed, 22 Feb 2012 11:13:32 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303372#M112249 2012-02-22T11:13:32Z Re: How to create group Articles for SubTotal https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303373#M112250 <HTML><HEAD></HEAD><BODY><P> Okay, if your questions now has been answered, please close the discussion as "Solved" so if someone in the future has a similar question they&nbsp; will know that this thread was solved. //brg Robert</P></BODY></HTML> Wed, 22 Feb 2012 12:57:15 GMT https://community.qlik.com/t5/QlikView/How-to-create-group-Articles-for-SubTotal/m-p/303373#M112250 RSvebeck 2012-02-22T12:57:15Z