Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Calculated Dimension in Pivot with Average function

Guys,

Can anyone tell me how can I create a calculated dimension properly?

I have a dimension with the name KIND RO.

I need to add the dimesion Processing Period to my pivot table as a calculated dimension. The calculation will be the average hours of processing period according to each Kind RO.

1 Solution

Accepted Solutions
rubenmarin

Hi Diana, maybe:

Aggr(Avg(Hours), Kind RO)

Sample data or further expanations will be nice if you want something different.

View solution in original post

1 Reply
rubenmarin

Hi Diana, maybe:

Aggr(Avg(Hours), Kind RO)

Sample data or further expanations will be nice if you want something different.

View solution in original post