topic Need help in logic in QlikView https://community.qlik.com/t5/QlikView/Need-help-in-logic/m-p/97128#M751851 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I want to know the count of distinct invoice no based on the selection of item category code.</P><P>for&nbsp; exemple in the data set</P><P>i want output as below</P><P>itemcategorycode&nbsp; no. of invoice</P><P>proease,2</P><P>because in&nbsp; invoice no (900012346,900020000) only proease item sold .</P><P></P><P>Similarly for itemcategorycode uniwash, no of distinct invoice 1(900012347),</P><P>and for itemcategorycode xpert no of distinct invoice 1(900012348)</P><P></P><P>Please find the attached excel file and do the needful.</P><P></P><P>Regards</P><P>RTR</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT tripatirao 2020-11-25T16:16:04Z Need help in logic https://community.qlik.com/t5/QlikView/Need-help-in-logic/m-p/97128#M751851 <HTML><HEAD></HEAD><BODY><P>Dear All,</P><P></P><P>I want to know the count of distinct invoice no based on the selection of item category code.</P><P>for&nbsp; exemple in the data set</P><P>i want output as below</P><P>itemcategorycode&nbsp; no. of invoice</P><P>proease,2</P><P>because in&nbsp; invoice no (900012346,900020000) only proease item sold .</P><P></P><P>Similarly for itemcategorycode uniwash, no of distinct invoice 1(900012347),</P><P>and for itemcategorycode xpert no of distinct invoice 1(900012348)</P><P></P><P>Please find the attached excel file and do the needful.</P><P></P><P>Regards</P><P>RTR</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Need-help-in-logic/m-p/97128#M751851 tripatirao 2020-11-25T16:16:04Z