topic Re: Dynamic grouping(count) based on Row no on different selection (Dimension) in Qliksense 2018 in App Development https://community.qlik.com/t5/App-Development/Dynamic-grouping-count-based-on-Row-no-on-different-selection/m-p/1934840#M77012 <P>Refer below blog&nbsp;</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867</A></P> <P>&nbsp;</P> Tue, 24 May 2022 13:07:25 GMT vinieme12 2022-05-24T13:07:25Z Dynamic grouping(count) based on Row no on different selection (Dimension) in Qliksense 2018 https://community.qlik.com/t5/App-Development/Dynamic-grouping-count-based-on-Row-no-on-different-selection/m-p/1934807#M77007 <P>Hi -</P> <P>I have a table with the data below.&nbsp;</P> <TABLE style="border-collapse: collapse; width: 288pt;" border="0" width="384" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" style="height: 14.5pt; width: 48pt;">Item</TD> <TD width="64" style="width: 48pt;">Category</TD> <TD width="64" style="width: 48pt;">Style</TD> <TD width="64" style="width: 48pt;">Item status</TD> <TD width="64" style="width: 48pt;">Retail price</TD> <TD width="64" style="width: 48pt;">Qty</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">A</TD> <TD>AN</TD> <TD>Curve</TD> <TD>Active</TD> <TD align="right">100</TD> <TD align="right">1</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">B</TD> <TD>AS</TD> <TD>Round</TD> <TD>InActive</TD> <TD align="right">200</TD> <TD align="right">5</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">C</TD> <TD>AD</TD> <TD>Flat</TD> <TD>Active</TD> <TD align="right">200</TD> <TD align="right">6</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">D</TD> <TD>AS</TD> <TD>Round</TD> <TD>InActive</TD> <TD align="right">300</TD> <TD align="right">7</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">E</TD> <TD>AD</TD> <TD>Flat</TD> <TD>Active</TD> <TD align="right">400</TD> <TD align="right">8</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">F</TD> <TD>AE</TD> <TD>Round</TD> <TD>Active</TD> <TD align="right">600</TD> <TD align="right">22</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>If I select 'AD' from Category and 'Flat' from Style I get this (adding row_no dynamic based on different selection critieria)</P> <TABLE style="border-collapse: collapse; width: 336pt;" border="0" width="448" cellspacing="0" cellpadding="0"> <TBODY> <TR style="height: 14.5pt;"> <TD width="64" height="19" style="height: 14.5pt; width: 48pt;">Item</TD> <TD width="64" style="width: 48pt;">Category</TD> <TD width="64" style="width: 48pt;">Style</TD> <TD width="64" style="width: 48pt;">Item status</TD> <TD width="64" style="width: 48pt;">Retail price</TD> <TD width="64" style="width: 48pt;">Qty</TD> <TD width="64" style="width: 48pt;">Row no</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">C</TD> <TD>AD</TD> <TD>Flat</TD> <TD>Active</TD> <TD align="right">200</TD> <TD align="right">6</TD> <TD align="right">1</TD> </TR> <TR style="height: 14.5pt;"> <TD height="19" style="height: 14.5pt;">E</TD> <TD>AD</TD> <TD>Flat</TD> <TD>Active</TD> <TD align="right">400</TD> <TD align="right">8</TD> <TD align="right">2</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Now, my requirement is to create a pivot table like this from the above table:</P> <TABLE width="317"> <TBODY> <TR> <TD width="125">&nbsp;</TD> <TD width="64">A Grade</TD> <TD width="64">B Grade</TD> <TD width="64">C Grade</TD> </TR> <TR> <TD>Condition (Row no)</TD> <TD>&lt;2</TD> <TD>&gt;1 and &lt; 4</TD> <TD>Others</TD> </TR> <TR> <TD>count(Qty)</TD> <TD>1</TD> <TD>2</TD> <TD>0</TD> </TR> </TBODY> </TABLE> <P>&nbsp;</P> <P>Any help would be much appreciated</P> Tue, 24 May 2022 12:16:42 GMT https://community.qlik.com/t5/App-Development/Dynamic-grouping-count-based-on-Row-no-on-different-selection/m-p/1934807#M77007 AC7 2022-05-24T12:16:42Z Re: Dynamic grouping(count) based on Row no on different selection (Dimension) in Qliksense 2018 https://community.qlik.com/t5/App-Development/Dynamic-grouping-count-based-on-Row-no-on-different-selection/m-p/1934840#M77012 <P>Refer below blog&nbsp;</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/Recipe-for-an-ABC-Analysis/ba-p/1472867</A></P> <P>&nbsp;</P> Tue, 24 May 2022 13:07:25 GMT https://community.qlik.com/t5/App-Development/Dynamic-grouping-count-based-on-Row-no-on-different-selection/m-p/1934840#M77012 vinieme12 2022-05-24T13:07:25Z