Discussion board where members can learn more about Qlik Sense App Development and Usage.
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 .
I have to create pivot table with these fields except Response No. but am not able to get response % correctly
What is your current not correct output and what is your desired output? Please explain.
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
Hope Response No is primary field, in that case, try like below
Avg(Aggr(Avg(Response %),[Response No]))
Hi Mayil Vahanan,
[Response no] is granular low level data and primary field . I have tried Average value is not showing correctly.