topic Re: Pivot tables sum criteria. in QlikView

Pivot tables sum criteria.

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

Hi Team,

I have requirment where we need to use pivot table with dimension Manager and Sales Rep and Measure are Sum(Sales) and Sum(Quota).

Here i have data of sales for only Sales Reps and quota for both sales Rep and Managers.

So is there a way to controla not to roll up the second dimenion measure value to the first dimention?

Let me know if any further queries.

Thanks

Sunil

Re: Pivot tables sum criteria.

sunny_talwar — Mon, 11 Dec 2017 14:43:28 GMT

Would you be able to share some raw data and show what you need as the solution from that data?

Re: Pivot tables sum criteria.

cmsunilkumar — Mon, 11 Dec 2017 14:53:23 GMT

Hi Sunny, i have two tables like above, where quota will be for both sales Rep and Manager which one field name.

How can i create a pivot in which Sum(Sales) of Sales Rep is Respective Managers Sales, but Quota needs to updated indiviudally in the Pivot table which is in 2nd table.

let me know if its not clear.

Thanks

Sunil

Re: Pivot tables sum criteria.

sunny_talwar — Mon, 11 Dec 2017 14:56:51 GMT

Sunil Kumar C M wrote:

How can i create a pivot in which Sum(Sales) of Sales Rep is Respective Managers Sales, but Quota needs to updated indiviudally in the Pivot table which is in 2nd table.

Would you be able to show the above in a table format also? It would help if I can see the the output you expect to see with the numbers you need

Re: Pivot tables sum criteria.

Anil_Babu_Samineni — Mon, 11 Dec 2017 15:09:28 GMT

How we are splitting to each. To understand and clubbing to one dimension you can try this?

Pick(Match($Field, 'Manager', 'Sales Rep'), Manager, [Sales Rep])

Re: Pivot tables sum criteria.

cmsunilkumar — Wed, 13 Dec 2017 09:44:52 GMT

Hi Sunny,

I am not able to keep this in table format.

here i am looking to be put in Pivot table where Manager sales is Sum(Sales) of his respective sales Reps and Quote from quota table.

Can you help if you ge any idea on model aswell..or best way to show?

Thanks

Sunil

Re: Pivot tables sum criteria.

cmsunilkumar — Wed, 13 Dec 2017 09:50:20 GMT

Hi Anil,

When you say $Field means here which field to be used?

Thanks

Sunil

Re: Pivot tables sum criteria.

shiveshsingh — Wed, 13 Dec 2017 10:22:34 GMT

$Field = Column's Value