Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
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

See attached example.


talk is cheap, supply exceeds demand