topic Expression in Pivot Table in QlikView

Expression in Pivot Table

Tue, 19 Feb 2013 14:14:57 GMT

Hi guys,

I'm in trouble with an expression in my pivot table.

The Pivot table has these dimensions:

District,

Area,

AreaManagerName,

SubAreaManagerName

At the moment, I've an expression that calculate how many SubAreaManager a single AreaManager has.

So in my pivot table I have this expression:

count({$<gradoPB={'060'}>}PBcode)

gradoPB = 060 says that the PB (identifyed by his codePB) is a SubAreaManager.

IT WORKS PERFECTLY.

Now, I want to calculate how many SubAreaManager with

(SUM(Field1) / SUM(Field2)) >= 0.2

a single AreaManager has.

I hope it's clear.

Can someone help me?

Thanks in advance

Giampiero

Tue, 19 Feb 2013 14:41:57 GMT

I have to put this condition in my set analysis.

If I can put this filter : SUM(Field1) / SUM(Field2)) >= 0.2

in this expression:

aggr(Count({$<gradoPB={'060'}>} codicePB),AreaManagerName)

I think I can solve the problem.

Any suggestion ?

Thanks

Giampiero

Thu, 21 Feb 2013 09:22:15 GMT

No one can help me?

😞