topic Re: Total Distribution Sold in QlikView

Total Distribution Sold

vadim_grab — Sun, 11 Jun 2017 09:04:30 GMT

Hi, Experts.

I'm working on task - SalesManager Dashboard.

I need any help to realize KPI -Total Distribution Sold (TDS), which present how many distinct SKU per Customer have sells manager in his territory per Month and Year .

Exapmle

Month Manager TDS = 12 000 SKU

Customers = 100

12 000 SKU / 100 = 1000 Distinct SKU per Customer

I use count(distinct SKU) to calculate individual TDS per Customer, but I have a trouble to calculate TDS per Month and Year, it must be sum all individual TDS customers.

In attached file- Excel Example

Many thanks for any help

Re: Total Distribution Sold

swuehl — Sun, 11 Jun 2017 10:29:18 GMT

Maybe try with advanced aggregation (aggr() function), something like an expression

=Sum( Aggr( Count(DISTINCT SKU), Manager, [Year-Month]) )

in a table chart with Manager and [Year-Month] dimensions,

Re: Total Distribution Sold

vadim_grab — Sun, 11 Jun 2017 14:20:37 GMT

Thanks Stephan!

It's worked, but only with two StructuredParameter AGGR()

That about more than 2 StructuredParameter for example Customer ->Manager ->Branch-> YearMonth ->Year?

Best Regards,

Vadim

Re: Total Distribution Sold

swuehl — Sun, 11 Jun 2017 14:56:19 GMT

Not sure I understand, so it would be helpful if you can post some sample data and your expected result on each aggregation level.

In general, you can add more aggr() dimensions, for example:

=Sum( Aggr( Count(DISTINCT SKU), Manager, Customer, [Year-Month]) )