topic Re: Assortment matrix in QlikView https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235245#M393033 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Tue, 21 Feb 2017 12:45:48 GMT kolov007 2017-02-21T12:45:48Z Assortment matrix https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235242#M393030 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>I have a problem. I need to count the number of unique items in each store, thus it is necessary to consider only those products whose number is greater than 0 (&gt;0). The document, which is attached as an attachment, at the level of display <SPAN style="font-size: 13.3333px;">products level</SPAN> everything works right, but to collapse the network level, the data is displayed incorrectly. </P><P>Help me please to solve this problem.</P><P><IMG alt="Screenshot_1.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/153895_Screenshot_1.jpg" style="height: 533px; width: 620px;" /><IMG alt="Screenshot_2.jpg" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/153899_Screenshot_2.jpg" style="height: 382px; width: 620px;" /></P></BODY></HTML> Tue, 21 Feb 2017 11:08:06 GMT https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235242#M393030 kolov007 2017-02-21T11:08:06Z Re: Assortment matrix https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235243#M393031 <HTML><HEAD></HEAD><BODY><P>Try this:</P><P></P><P><STRONG>Sum(Aggr(If(Sum(Amount) &gt; 0, Count(DISTINCT Product)), Product, Shop))</STRONG></P></BODY></HTML> Tue, 21 Feb 2017 11:14:30 GMT https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235243#M393031 sunny_talwar 2017-02-21T11:14:30Z Re: Assortment matrix https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235244#M393032 <HTML><HEAD></HEAD><BODY><P>May be use this</P><P></P><P><STRONG>Sum(If(Sum(Amount) &gt; 0, Aggr(Count(DISTINCT Product)), Product, Shop))</STRONG></P></BODY></HTML> Tue, 21 Feb 2017 11:17:20 GMT https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235244#M393032 Anil_Babu_Samineni 2017-02-21T11:17:20Z Re: Assortment matrix https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235245#M393033 <HTML><HEAD></HEAD><BODY><P>Thank you</P></BODY></HTML> Tue, 21 Feb 2017 12:45:48 GMT https://community.qlik.com/t5/QlikView/Assortment-matrix/m-p/1235245#M393033 kolov007 2017-02-21T12:45:48Z