PIVOT (Calculation)

[hkg_qlik]

Hi,

I am building a PIVOT table. I have been facing issue in getting the Correct AVG(Average) values for the table.

I have attached an Excel to showcase the issue.

Thanks,

H

[#2]

Hi,

Based on the excel, it looks like you need average days aggregated over cycle and code. If this is the case, this expression may work:  aggr(avg(DAYS),Cycle, Code)

If you upload a qvw this would be easier to test.

Hope that helps.

Matt

[Gysbert_Wassenaar]

See attached example.