Discussion Board for collaboration related to QlikView App Development.
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.
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