Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

4 Replies
rubenmarin

Hi, maybe with:

Count(DISTINCT {<[invoice no]={"=Count({1}Distinct [item category code])=1"}>} [invoice no])

tripatirao
Creator II
Creator II
Author

Dear ,

thanks for your response

i will apply the code and get back to you.

tripatirao
Creator II
Creator II
Author

Dear,

Your code is worked for me.

Can you please help me on the below requirement.

I need to show no of invoice for the combination of item category code.

please find the attached excel

rubenmarin

Hi Tripati, maybe you can create a table with a calculated dimension:

=Aggr(Concat(DISTINCT [item category code],'+'), [invoice no])

And the expression:

Count(DISTINCT [invoice no])