Qlik Community

Ask a Question

App Development

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

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
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

Labels (1)
4 Replies
Vegar
Partner
Partner

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

 

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
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.