topic Re: a reduction question in QlikView

a reduction question

ali_hijazi — Wed, 30 Nov 2016 12:34:01 GMT

I'm comparing net sales of a salesman to total net sales and the result is fine

However now we are reducing the document by salesman so total net sales will be that of the salesman

How can I reduce a document by salesman and keep total sales?

Re: a reduction question

sunny_talwar — Wed, 30 Nov 2016 12:37:53 GMT

reducing using section access you mean?

Re: a reduction question

Miguel_Angel_Baeyens — Wed, 30 Nov 2016 12:41:12 GMT

You need to preaggreate in the script so the total overall is always there and each salesman can see it, but they cannot see the details. Usually a LOAD ... GROUP BY ... will work.

Re: a reduction question

tresB — Wed, 30 Nov 2016 12:42:25 GMT

Create an additional column with total sale. May be like:

Temp:

Load

State,

Sales,

Customer

From <>;

Join

Load

State,

Sum(Sales) as TotalSales

Resident Temp group By State;

Re: a reduction question

ali_hijazi — Wed, 30 Nov 2016 12:43:27 GMT

yes

Re: a reduction question

ali_hijazi — Wed, 30 Nov 2016 12:46:21 GMT

I thought of this but at first I thought there might be another workaround

Re: a reduction question

Miguel_Angel_Baeyens — Wed, 30 Nov 2016 12:51:55 GMT

There is none, data must be there and cannot be reduced or accomplished using Aggr() or Set Analysis because data is not actually there.

Well, you can also add another column while extracting from the source but that likely means repeated values, and you can also do the aggregation in the SQL statement, and not the LOAD statement, from the performance point of view the latter is wiser.