Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
hkg_qlik
Creator III
Creator III

PIVOT (Calculation)

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 Replies
Not applicable

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
Partner - Champion III
Partner - Champion III

See attached example.


talk is cheap, supply exceeds demand