Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

tripatirao
Contributor II

Need help in logic

Dear All,

I want to know the count of distinct invoice no based on the selection of item category code.

for  exemple in the data set

i want output as below

itemcategorycode  no. of invoice

proease,2

because in  invoice no (900012346,900020000) only proease item sold .

Similarly for itemcategorycode uniwash, no of distinct invoice 1(900012347),

and for itemcategorycode xpert no of distinct invoice 1(900012348)

Please find the attached excel file and do the needful.

Regards

RTR

3 Replies
vishsaggi
Esteemed Contributor III

Re: Need help in logic

Hello Tripati, you created 2 duplicates of this thread. Can you delete them and keep one please.

Thanks,
v.

Partner
Partner

Re: Need help in logic

HI,

first thing to get the distinct count

COUNT(Distinct [Invoice No])

Then you can ether add filters to the front end to filter the value or build up your set analysis like

COUNT({<itemcategorycode ={'proease'}>}Distinct [Invoice No])


Mark

vishsaggi
Esteemed Contributor III

Re: Need help in logic

Add item category code as your Dimension and expr as below:

= Count(DISTINCT [invoice no])

Using straight table chart.