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

vishsaggi — Wed, 31 Oct 2018 16:40:26 GMT

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

Thanks,
v.

Mark_Little — Wed, 31 Oct 2018 16:55:58 GMT

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 — Wed, 31 Oct 2018 18:21:29 GMT

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

= Count(DISTINCT [invoice no])

Using straight table chart.