topic Re: Creating % analytics in QlikView https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608131#M478685 <HTML><HEAD></HEAD><BODY><P>Clicked it, doesn't make any change unless I am doing something wrong??</P></BODY></HTML> Thu, 06 Mar 2014 09:42:03 GMT 2014-03-06T09:42:03Z Creating % analytics https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608129#M478683 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I have a chart to which I am trying to show a % of products used.&nbsp; However, I've hit a dead end asto how to create this.&nbsp; I currently have the following expression which gives me the total value of the product used:</P><P></P><P>=num(sum(OKM_POTENTIALVALUE)</P><P></P><P>I want to then divide this into the total for a specific procedure which the expression is the same.&nbsp; Any ideas on how I can do this?</P><P>(The tab in question is the Consumable tab)</P><P></P><P>(Hope it makes sense)</P></BODY></HTML> Thu, 06 Mar 2014 09:17:05 GMT https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608129#M478683 2014-03-06T09:17:05Z Re: Creating % analytics https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608130#M478684 <HTML><HEAD></HEAD><BODY><P>Check 'Relative' in the expression tab, check the output, is this what you want?</P></BODY></HTML> Thu, 06 Mar 2014 09:37:09 GMT https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608130#M478684 tresB 2014-03-06T09:37:09Z Re: Creating % analytics https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608131#M478685 <HTML><HEAD></HEAD><BODY><P>Clicked it, doesn't make any change unless I am doing something wrong??</P></BODY></HTML> Thu, 06 Mar 2014 09:42:03 GMT https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608131#M478685 2014-03-06T09:42:03Z Re: Creating % analytics https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608132#M478686 <HTML><HEAD></HEAD><BODY><P>Did you try it in your pie chart? and yes check 'Values on data points' as well, you would notice the change. See how I see:</P><P><IMG alt="111.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/54382_111.png" /></P></BODY></HTML> Thu, 06 Mar 2014 09:45:05 GMT https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608132#M478686 tresB 2014-03-06T09:45:05Z Re: Creating % analytics https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608133#M478687 <HTML><HEAD></HEAD><BODY><P>Perfect!!!!&nbsp; Something so simple has kept me stuck for days. </P><P></P><P>Thank you!</P></BODY></HTML> Thu, 06 Mar 2014 09:49:25 GMT https://community.qlik.com/t5/QlikView/Creating-analytics/m-p/608133#M478687 2014-03-06T09:49:25Z