topic count Product by ID in QlikView

topic count Product by ID in QlikView https://community.qlik.com/t5/QlikView/count-Product-by-ID/m-p/73768#M788124 <HTML><HEAD></HEAD><BODY><P>Can some one help me to count the Product by ID</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">LOAD * INLINE [</P><P style="font-size: 13.3333px;">    ID, Product</P><P style="font-size: 13.3333px;">    1, AA</P><P style="font-size: 13.3333px;">    2, BB</P><P style="font-size: 13.3333px;">    2, BB</P><P style="font-size: 13.3333px;">    2, CC</P><P style="font-size: 13.3333px;">    3, DD</P><P style="font-size: 13.3333px;">    3, AA</P><P style="font-size: 13.3333px;">    4, AA</P><P style="font-size: 13.3333px;">    4, BB</P><P style="font-size: 13.3333px;">    4, DD</P><P style="font-size: 13.3333px;">];</P><P><IMG alt="count.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194260_count.PNG" style="height: 187px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT karan_kn 2020-11-25T16:16:04Z count Product by ID https://community.qlik.com/t5/QlikView/count-Product-by-ID/m-p/73768#M788124 <HTML><HEAD></HEAD><BODY><P>Can some one help me to count the Product by ID</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">LOAD * INLINE [</P><P style="font-size: 13.3333px;">    ID, Product</P><P style="font-size: 13.3333px;">    1, AA</P><P style="font-size: 13.3333px;">    2, BB</P><P style="font-size: 13.3333px;">    2, BB</P><P style="font-size: 13.3333px;">    2, CC</P><P style="font-size: 13.3333px;">    3, DD</P><P style="font-size: 13.3333px;">    3, AA</P><P style="font-size: 13.3333px;">    4, AA</P><P style="font-size: 13.3333px;">    4, BB</P><P style="font-size: 13.3333px;">    4, DD</P><P style="font-size: 13.3333px;">];</P><P><IMG alt="count.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194260_count.PNG" style="height: 187px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/count-Product-by-ID/m-p/73768#M788124 karan_kn 2020-11-25T16:16:04Z Re: count Product by ID https://community.qlik.com/t5/QlikView/count-Product-by-ID/m-p/73769#M788125 <HTML><HEAD></HEAD><BODY><P>try with </P><P></P><P>=count(Distinct Product)</P><P><IMG alt="dis.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/194263_dis.JPG" style="height: auto;" /></P></BODY></HTML> Thu, 22 Feb 2018 18:36:58 GMT https://community.qlik.com/t5/QlikView/count-Product-by-ID/m-p/73769#M788125 Chanty4u 2018-02-22T18:36:58Z