topic Re: Variable from Pivot table data in QlikView

Variable from Pivot table data

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

I have a pivot table with the amount of worked days for each employee,calculated as expressions from the employees' activities, per year. I need to calculate an average an worked days per year and use the said average on some other pivot tables. So as a solution I was thinking about making the said average a variable that I can call in other pivot tables.

Now the question is:

Is there a way in which I can reference an expression in a pivot table, when calculating a variable? If not, is there any other solution to my problem?

Re: Variable from Pivot table data

Anil_Babu_Samineni — Thu, 04 Jan 2018 15:54:35 GMT

Could be

Aggr(Avg(TOTAL <day> [Worked Days Expression], year))

Re: Variable from Pivot table data

Anil_Babu_Samineni — Thu, 04 Jan 2018 15:55:13 GMT

Could be

Aggr(Avg(TOTAL <day> [Worked Days Expression], year))

Re: Variable from Pivot table data

marcus_sommer — Thu, 04 Jan 2018 15:59:46 GMT

You couldn't put the multiple results of a pivot within a variable and also you couldn't refer from one object to another. You will always need to calculate your needed results within one object.

In your case you might be getting your results with nested aggregations with the aggr-function, maybe something like this:

avg(aggr(count(WorkingDays), Employee, Year))

To get an explanation what is meant, see: AGGR...

- Marcus