topic Re: Help with expression in QlikView https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439888#M163968 <HTML><HEAD></HEAD><BODY><P>Please correct me if i am wrong</P></BODY></HTML> Sat, 15 Dec 2012 07:15:37 GMT 2012-12-15T07:15:37Z Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439885#M163965 <HTML><HEAD></HEAD><BODY><P>Hi All, </P><P></P><P>I am trying to show percentage(marked in yellow) of indivdual values to sum of total values </P><P></P><P>Here i need to achieve ration (individulas to total) in an expression ...</P><P></P><TABLE border="1" cellpadding="0" cellspacing="0" style="border: none;"><TBODY><TR><TD style="border: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">Year </P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">Vendor</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">Units</P></TD><TD style="border: solid windowtext 1.0pt; border-left: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;"><SPAN style="background: yellow;">Ratio</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">2012</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">A</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">30000000</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P><SPAN style="background: yellow;">42.85%</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">2012</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">B</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">26000000</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P><SPAN style="background: yellow;">37.14%</SPAN></P></TD></TR><TR><TD style="border: solid windowtext 1.0pt; border-top: none; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">2012</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">C</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P style="margin-bottom: 0.0001pt;">14000000</P></TD><TD style="border-top: none; border-left: none; border-bottom: solid windowtext 1.0pt; border-right: solid windowtext 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="top" width="200"><P><SPAN style="background: yellow;">20.00%</SPAN></P></TD></TR></TBODY></TABLE></BODY></HTML> Sat, 15 Dec 2012 06:02:48 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439885#M163965 2012-12-15T06:02:48Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439886#M163966 <HTML><HEAD></HEAD><BODY><P>can&nbsp; u explain more ?</P></BODY></HTML> Sat, 15 Dec 2012 07:07:43 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439886#M163966 2012-12-15T07:07:43Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439887#M163967 <HTML><HEAD></HEAD><BODY><P>i guess the expression for caliculating ratio will be&nbsp; ... </P><P></P><P></P><P>=num</P><P>(</P><P>sum(Units)</P><P>/</P><P>Sum(TOTAL &lt;Year&gt; Units),'#.##%')</P></BODY></HTML> Sat, 15 Dec 2012 07:14:48 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439887#M163967 2012-12-15T07:14:48Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439888#M163968 <HTML><HEAD></HEAD><BODY><P>Please correct me if i am wrong</P></BODY></HTML> Sat, 15 Dec 2012 07:15:37 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439888#M163968 2012-12-15T07:15:37Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439889#M163969 <HTML><HEAD></HEAD><BODY><P>yes,it shud work...</P><P>haven't u tried it yet ?</P></BODY></HTML> Sat, 15 Dec 2012 07:18:20 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439889#M163969 2012-12-15T07:18:20Z Re: Help with expression https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439890#M163970 <HTML><HEAD></HEAD><BODY><P style="background-color: #ffffff; color: #737373; font-family: Arial;">sum(Units)</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">/</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Sum(TOTAL &lt;Year,<SPAN style="color: #737373; font-family: Arial; background-color: #ffffff;">Vendor</SPAN>&gt; Units),'#.##%')</P><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">hope this helps</P></BODY></HTML> Sat, 15 Dec 2012 13:06:35 GMT https://community.qlik.com/t5/QlikView/Help-with-expression/m-p/439890#M163970 SunilChauhan 2012-12-15T13:06:35Z