https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853727#M1215780 <P>Thanks, it works perfectly</P> Fri, 29 Oct 2021 15:03:06 GMT Kelvin93 2021-10-29T15:03:06Z https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853692#M1215777 <P>Hi, i've 2 tables, one with my articles db and the second with a promoid and the articleid. I wanna create something like this:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kelvin93_0-1635516286378.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65620i34B15E2AF4BB183F/image-size/medium?v=v2&amp;px=400" role="button" title="Kelvin93_0-1635516286378.png" alt="Kelvin93_0-1635516286378.png" /></span></P> <P>The tables looks like:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Kelvin93_1-1635516445120.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65621iEEBE02D0C5CC5441/image-size/medium?v=v2&amp;px=400" role="button" title="Kelvin93_1-1635516445120.png" alt="Kelvin93_1-1635516445120.png" /></span></P> <P>How can i achive this with qlik?</P> <P>&nbsp;</P> Fri, 29 Oct 2021 14:08:29 GMT https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853692#M1215777 Kelvin93 2021-10-29T14:08:29Z https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853701#M1215779 <P>Hello,</P> <P>Try like below.</P> <P>Create a link between both tables on <STRONG>ArticleID.</STRONG></P> <P>Take a pivot table, <STRONG>Rows</STRONG>: Article, ArticleDescription. <STRONG>Column</STRONG> : PromoID</P> <P><STRONG>Measure</STRONG> : Count(Distinct PromoID)</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="AshutoshBhumkar_1-1635518132183.png" style="width: 550px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/65623iC94697EE46101756/image-dimensions/550x165?v=v2" width="550" height="165" role="button" title="AshutoshBhumkar_1-1635518132183.png" alt="AshutoshBhumkar_1-1635518132183.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>Thanks,</P> <P>Ashutosh</P> <P>&nbsp;</P> Fri, 29 Oct 2021 14:35:44 GMT https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853701#M1215779 AshutoshBhumkar 2021-10-29T14:35:44Z https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853727#M1215780 <P>Thanks, it works perfectly</P> Fri, 29 Oct 2021 15:03:06 GMT https://community.qlik.com/t5/QlikView/Create-Matrix-with-flag-if-exist/m-p/1853727#M1215780 Kelvin93 2021-10-29T15:03:06Z