topic How to get relative % while using Pivot charts in QlikView https://community.qlik.com/t5/QlikView/How-to-get-relative-while-using-Pivot-charts/m-p/191074#M53309 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Can anybody guide me to get "relative %" while using Pivot charts .</P><P>We can able to get it if we use striaght table , but unable to achieve the same using Pivot drill down options.</P><P></P><P>Regards,</P><P>Bhushan N</P></BODY></HTML> Wed, 24 Mar 2010 06:40:42 GMT 2010-03-24T06:40:42Z How to get relative % while using Pivot charts https://community.qlik.com/t5/QlikView/How-to-get-relative-while-using-Pivot-charts/m-p/191074#M53309 <HTML><HEAD></HEAD><BODY><P>Hi ,</P><P>Can anybody guide me to get "relative %" while using Pivot charts .</P><P>We can able to get it if we use striaght table , but unable to achieve the same using Pivot drill down options.</P><P></P><P>Regards,</P><P>Bhushan N</P></BODY></HTML> Wed, 24 Mar 2010 06:40:42 GMT https://community.qlik.com/t5/QlikView/How-to-get-relative-while-using-Pivot-charts/m-p/191074#M53309 2010-03-24T06:40:42Z How to get relative % while using Pivot charts https://community.qlik.com/t5/QlikView/How-to-get-relative-while-using-Pivot-charts/m-p/191075#M53310 <HTML><HEAD></HEAD><BODY><P>You have to create separate expression for that..</P><P>1. Count(Problem_ID) - it gives you the count</P><P>2. Count(Problem_ID)/Count(Total Problem_ID) - it gives you the relative %. In number tab, you ve to choose Show in % option or use (Count(Problem_ID)/Count(Total Problem_ID))*100 to get the %</P></BODY></HTML> Wed, 24 Mar 2010 09:53:04 GMT https://community.qlik.com/t5/QlikView/How-to-get-relative-while-using-Pivot-charts/m-p/191075#M53310 2010-03-24T09:53:04Z