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

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])