Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Leninond
Contributor
Contributor

Aggr() issue in pivot table

Hi,

I having scenario to do aggregation at chart and pivot table level. I  have created (Month, Quarterly,  Half yearly and Yearly) base on the date field .

Response NoProject IDDateAccountSub AccountTowerSub  TowerResponse %
23307384902-Apr-2020Good willsABMLDDIV80.00%
23702384906-Apr-2020Good willsABMLDDIV100.00%
23767604614-Apr-2020Good willsSCMLDDIV100.00%
238131200028-Apr-2020Good willsALLMLDDIV60.00%
238211037421-Apr-2020Good willsHAMLDDIV80.00%
239341014912-May-2020Good willsLPMLDDIV80.00%
239521097407-May-2020Good willsGMBHMLDDIV100.00%
24004731214-May-2020Good willsBEMLDDIV100.00%
241191089929-May-2020Good willsBEMLDDIV100.00%
241201083627-May-2020Good willsBEMLDDIV100.00%
24131862202-Jun-2020Good willsLPMLDDIV80.00%
24135885305-Jun-2020Good willsBEMLDDIV100.00%
241361131428-May-2020Good willsLAEMLDDIV80.00%
24143940828-May-2020Good willsMOMLDDIV80.00%
24148438829-May-2020Good willsDMMLDDIV80.00%
241501138729-May-2020Good willsPALMLDDIV80.00%
241511154802-Jun-2020Good willsPALMLDDIV100.00%
24153480201-Jun-2020Good willsVIDMLDDIV80.00%
241811176902-Jun-2020Good willsDMMLDDIV80.00%
24192975204-Jun-2020Good willsBEMLDDIV80.00%
24202975208-Jun-2020Good willsBEMLDDIV100.00%
24242257417-Jun-2020Good willsVIDMLDDIV100.00%
242491260916-Jun-2020GRBTHOMLDDIV80.00%
24403913809-Jul-2020Good willsBEMLDDIV100.00%
244741076102-Jul-2020Good willsBEMLDDIV100.00%
246111085209-Jul-2020Good willsBEMLDDIV100.00%
246381014924-Jul-2020Good willsLPMLDDIV80.00%
24691604619-Jul-2020Good willsSCMLDDIV100.00%
247391264931-Jul-2020Good willsGMBHMLDDIV80.00%
249711165420-Aug-2020Good willsHAMLDDIV80.00%
249791234531-Aug-2020Good willsMOMLDDIV80.00%
24980763621-Aug-2020Good willsLPMLDDIV80.00%
25068384931-Aug-2020Good willsABMLDDIV100.00%
25115551431-Aug-2020Good willsLEMLDDIV80.00%
252231083616-Sep-2020Good willsBEMLDDIV100.00%
252621200021-Sep-2020Good willsALMLDDIV60.00%
252991138724-Sep-2020Good willsPALMLDDIV80.00%
25501604612-Oct-2020Good willsSCMLDDIV100.00%
255411291412-Oct-2020Good willsDMMLDDIV100.00%
256581131420-Oct-2020Good willsLAEMLDDIV100.00%
25736384928-Oct-2020Good willsABMLDDIV100.00%

I have to create pivot table with these fields except Response No. but am not able to get response % correctly

4 Replies
Vegar
MVP
MVP

What is your current not correct output and what is your desired output? Please explain.

 

Leninond
Contributor
Contributor
Author

i have created pivot table with this data

Dimensions : Project ID, Account, Sub Account, Tower, Sub Tower, Month, Qtr, Half year and year

expression : Avg(Aggr(Avg(Response %),Project ID, Account, Sub Account, Tower, Sub Tower, Month, Qtr, Half year , year))

Base on this expression the rollup % values are not coming correctly 

MayilVahanan

Hi @Leninond 

Hope Response No is primary field, in that case, try like below

Avg(Aggr(Avg(Response %),[Response No]))

Thanks & Regards,
Mayil Vahanan R
Leninond
Contributor
Contributor
Author

Hi Mayil Vahanan,

[Response no] is granular low level data and primary field . I have tried Average value is not showing correctly.