topic Re: Altering Distint Count through Drill in QlikView

Altering Distint Count through Drill

matthewjbryant — Tue, 07 Jul 2015 08:45:38 GMT

I have a table of deliveries where each delivery can have multiple parts on it. I want to create a drill through company to part that counts the deliveries as distinct relative to the dimension. Deliveries are not split at a company level, but are at a part level.

I have produced a QVW of what I want to see, but it is hard coded with if(GetCurrentField(), which is not ideal because in my live document I use a dynamic drill the user can change the dimensions should they wish.

Is there a better way?

Re: Altering Distint Count through Drill

lironbaram — Tue, 07 Jul 2015 08:59:52 GMT

may be i am missing something

but why not use a simple

count(distinct Delivery)

Re: Altering Distint Count through Drill

matthewjbryant — Tue, 07 Jul 2015 09:07:11 GMT

Thanks for the response Liron. I've amended the Drill table to show why. I need the Delivery Count column to be replicated, but I can't get this with a simple Count(Distinct()). On the company level one field is correct, but on the part level the other is correct.

Re: Altering Distint Count through Drill

lironbaram — Tue, 07 Jul 2015 10:14:19 GMT

hi Matthew

i think the correct total from business perspective should be 2 even

when you look at part as dimension because you really have only 2 deliveries and not 5

i didn't manage to see a problem in the new model, what were you refering to?