topic Urgent: Pivot Chart Averages in QlikView https://community.qlik.com/t5/QlikView/Urgent-Pivot-Chart-Averages/m-p/347048#M494446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use Branch as dimension and four individual expression for each week (9, 10, 11, 12) and another expression for </P><P></P><P>Total average number by using {1}.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Wed, 11 Apr 2012 15:04:40 GMT jagan 2012-04-11T15:04:40Z Urgent: Pivot Chart Averages https://community.qlik.com/t5/QlikView/Urgent-Pivot-Chart-Averages/m-p/347047#M494445 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Hi all,</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">I need help representing the averages in a pivot chart. I have four dimensions (Branch, Week, Dimension3, Dimension4) and one measure (number of customers) in my raw data. I am creating a pivot chart with two dimensions (Branch and Week). I want to create another pivot chart in which i want to show only 4 four specific weeks (for example 9,10,11,12), but i still want to retain the total average number. Find attached the excel which shows the existing and desired pivot charts.</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Any ideas on how this can be done?</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"> </SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Tkx,</SPAN><BR /><SPAN style="font-family: calibri, verdana, arial, sans-serif;">Harsha</SPAN></P></BODY></HTML> Wed, 11 Apr 2012 13:54:58 GMT https://community.qlik.com/t5/QlikView/Urgent-Pivot-Chart-Averages/m-p/347047#M494445 2012-04-11T13:54:58Z Urgent: Pivot Chart Averages https://community.qlik.com/t5/QlikView/Urgent-Pivot-Chart-Averages/m-p/347048#M494446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Use Branch as dimension and four individual expression for each week (9, 10, 11, 12) and another expression for </P><P></P><P>Total average number by using {1}.</P><P></P><P>Hope this helps you.</P><P></P><P>Regards,</P><P>jagan.</P></BODY></HTML> Wed, 11 Apr 2012 15:04:40 GMT https://community.qlik.com/t5/QlikView/Urgent-Pivot-Chart-Averages/m-p/347048#M494446 jagan 2012-04-11T15:04:40Z