Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
tripatirao
Creator II
Creator 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
Champion III
Champion III

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

Thanks,
v.

mark6505
Partner
Partner

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
Champion III
Champion III

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

= Count(DISTINCT [invoice no])

Using straight table chart.