topic Re: % measure in QlikView https://community.qlik.com/t5/QlikView/measure/m-p/1102050#M915914 <HTML><HEAD></HEAD><BODY><P>I think you might want to move the third expression to the right axis as the budget and Actual PO might be huge values and the % might be too small to be visual on the same axis.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125070_Capture.PNG" style="height: auto;" /></P><P></P><P>Pick your third expression from the Expressions above and select Right (Top) option</P></BODY></HTML> Thu, 19 May 2016 13:21:45 GMT sunny_talwar 2016-05-19T13:21:45Z % measure https://community.qlik.com/t5/QlikView/measure/m-p/1102048#M915912 <HTML><HEAD></HEAD><BODY><P>Hello Community,</P><P>I have a graph with 2 measures as you can see bellow and I need to add another measure to calculate the % consumed of the budget</P><P>What is the formula?</P><P></P><P>Thanks for your help</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125014_Capture.PNG" style="height: 283px; width: 620px;" /></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/measure/m-p/1102048#M915912 master_student 2020-11-25T16:16:04Z Re: % measure https://community.qlik.com/t5/QlikView/measure/m-p/1102049#M915913 <HTML><HEAD></HEAD><BODY><P>Maybe like</P><P></P><P>= Column(1) / Column(2)</P><P></P><P>or</P><P></P><P>="Actual PO" / "Budget"</P><P></P><P>and setting the number format on number tab to percentage.</P></BODY></HTML> Thu, 19 May 2016 13:07:25 GMT https://community.qlik.com/t5/QlikView/measure/m-p/1102049#M915913 swuehl 2016-05-19T13:07:25Z Re: % measure https://community.qlik.com/t5/QlikView/measure/m-p/1102050#M915914 <HTML><HEAD></HEAD><BODY><P>I think you might want to move the third expression to the right axis as the budget and Actual PO might be huge values and the % might be too small to be visual on the same axis.</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125070_Capture.PNG" style="height: auto;" /></P><P></P><P>Pick your third expression from the Expressions above and select Right (Top) option</P></BODY></HTML> Thu, 19 May 2016 13:21:45 GMT https://community.qlik.com/t5/QlikView/measure/m-p/1102050#M915914 sunny_talwar 2016-05-19T13:21:45Z Re: % measure https://community.qlik.com/t5/QlikView/measure/m-p/1102051#M915915 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny and Swuel. I combined your solutions and the result is :</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/125071_Capture.PNG" style="height: 276px; width: 620px;" /></P></BODY></HTML> Thu, 19 May 2016 13:33:31 GMT https://community.qlik.com/t5/QlikView/measure/m-p/1102051#M915915 master_student 2016-05-19T13:33:31Z