topic Re: Grouping Selection in QlikView https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387869#M422380 <HTML><HEAD></HEAD><BODY><P>The attached app is how it is suppose to work when you select sales in this app.</P></BODY></HTML> Tue, 14 Nov 2017 10:55:12 GMT sibusiso90 2017-11-14T10:55:12Z Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387866#M422377 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I was assisted yesterday with group selections but now I am stuck on how to apply it on my model as I use valuelist instead of a field as a dimension and I can't use cross table as it is a huge table with over 100 columns and about 1m rows which as growing daily.</P><P></P><P>The answered one is on the link below</P><P><A href="https://community.qlik.com/message/1380546">Grouping selection.</A></P><P></P><P>Attached is a model identical to my situation</P><P></P><P><A href="https://community.qlik.com/qlik-users/171708">stalwar1</A>‌</P><P><A href="https://community.qlik.com/qlik-users/26418">tresesco</A>‌</P><P></P><P>Thanks</P></BODY></HTML> Tue, 14 Nov 2017 10:29:03 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387866#M422377 sibusiso90 2017-11-14T10:29:03Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387867#M422378 <HTML><HEAD></HEAD><BODY><P>Could you explain here about your expected output/behavior against the sample data you provided?</P></BODY></HTML> Tue, 14 Nov 2017 10:44:41 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387867#M422378 tresB 2017-11-14T10:44:41Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387868#M422379 <HTML><HEAD></HEAD><BODY><P>When I select Group2 only sale1 and sale2 must appear with all the data in sale1 and sale2.</P><P>See picture below.</P><P><IMG alt="Select Group2.png" class="jive-image image-1" src="/legacyfs/online/183148_Select Group2.png" style="height: 266px; width: 620px;" /></P></BODY></HTML> Tue, 14 Nov 2017 10:52:34 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387868#M422379 sibusiso90 2017-11-14T10:52:34Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387869#M422380 <HTML><HEAD></HEAD><BODY><P>The attached app is how it is suppose to work when you select sales in this app.</P></BODY></HTML> Tue, 14 Nov 2017 10:55:12 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387869#M422380 sibusiso90 2017-11-14T10:55:12Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387870#M422381 <HTML><HEAD></HEAD><BODY><P>How are you planning to select sale? Sale is a valuelist dimension and AFAIK, it can't be selected....</P></BODY></HTML> Tue, 14 Nov 2017 11:01:51 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387870#M422381 sunny_talwar 2017-11-14T11:01:51Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387871#M422382 <HTML><HEAD></HEAD><BODY><P>This is simplified but there is another field that I will use to select. If only there is a way I can put the value list in my set analysis to be used to group.</P></BODY></HTML> Tue, 14 Nov 2017 11:07:29 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387871#M422382 sibusiso90 2017-11-14T11:07:29Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387872#M422383 <HTML><HEAD></HEAD><BODY><P>Valuelist can't be added to set analysis... can you share the field that you are going to be using for selection?</P></BODY></HTML> Tue, 14 Nov 2017 11:10:18 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387872#M422383 sunny_talwar 2017-11-14T11:10:18Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387873#M422384 <HTML><HEAD></HEAD><BODY><P>I made a mistake when I was explaining above sorry.</P><P>When you go the qvw I attached initially, Named "<STRONG><SPAN style="text-decoration: underline;">Selection by Group2.qvw</SPAN>". </STRONG>I will be using groups to select. That is the field I will be selecting with.</P></BODY></HTML> Tue, 14 Nov 2017 11:17:22 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387873#M422384 sibusiso90 2017-11-14T11:17:22Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387874#M422385 <HTML><HEAD></HEAD><BODY><P>Unable to do this... will keep trying though and will get back if I can find a way to do this</P></BODY></HTML> Tue, 14 Nov 2017 11:57:26 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387874#M422385 sunny_talwar 2017-11-14T11:57:26Z Re: Grouping Selection https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387875#M422386 <HTML><HEAD></HEAD><BODY><P>Thanks I will highly appreciate it. if there is a different way please let me know.</P></BODY></HTML> Tue, 14 Nov 2017 12:04:21 GMT https://community.qlik.com/t5/QlikView/Grouping-Selection/m-p/1387875#M422386 sibusiso90 2017-11-14T12:04:21Z