topic Re: Need help in logic in QlikView

Need help in logic

tripatirao — Wed, 25 Nov 2020 16:16:04 GMT

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

rubenmarin — Wed, 31 Oct 2018 16:53:42 GMT

Hi, maybe with:

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

tripatirao — Wed, 31 Oct 2018 18:27:34 GMT

Dear ,

thanks for your response

i will apply the code and get back to you.

tripatirao — Fri, 02 Nov 2018 08:17:11 GMT

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 — Fri, 02 Nov 2018 08:25:26 GMT

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