Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

hkg_qlik
Contributor II

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

Tags (1)
2 Replies
Not applicable

Re: PIVOT (Calculation)

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

Re: PIVOT (Calculation)

See attached example.


talk is cheap, supply exceeds demand
Community Browser