topic Calculate % based on parameter in QlikView https://community.qlik.com/t5/QlikView/Calculate-based-on-parameter/m-p/817823#M1042155 <HTML><HEAD></HEAD><BODY><P>Hello Qlikview wizards,</P><P></P><P>I'm trying to calculate % based on a parameter.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border: 0.5pt solid gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>WH_Cd</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Aisle_Desc</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Article_CW</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Sum_Colli</STRONG></SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; height: 12.75pt; background-color: whitesmoke;"><SPAN style="font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD class="xl64" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD class="xl64" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD align="right" class="xl65" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black gainsboro gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG>370</STRONG></SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Traiteur</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">62</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">Y</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">152</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Zuivel</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">145</SPAN></TD></TR></TBODY></TABLE><P></P><P>The result I want is this (the last column represents the percentages):</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;#FFFFFF&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 496px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border: 0.5pt solid gainsboro; width: 74pt; height: 12.75pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 279.34px; background-color: white;" width="135"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">Y</SPAN></TD><TD class="xl68" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">152</SPAN></TD><TD class="xl69" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 50pt; background-color: white;" width="67"><SPAN style="color: #333333; font-family: Tahoma;">41,08</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">62</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">16,76</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Zuivel + PBL_Traiteur</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">156</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">42,16</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD class="xl67" style="border: 0px windowtext; background-color: transparent;"></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">370</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">100</SPAN></TD></TR></TBODY></TABLE><P></P><P>The expression</P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="; color: #ff0000; font-size: 8pt;"><STRONG>(</STRONG></SPAN><SPAN style="font-size: 8pt;">{$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Article_CW]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"Y"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">&gt;}/ </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Article]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt; 99999"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[WH_Cd]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"12"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P>Wont work because I'm deviding two fields with the same result (370/ 370).</P><P></P><P>I'll attach this example in a qvw so it's easier to follow what I'm trying to accomplish.</P><P>Kind regards,</P><P>Ambertje</P></BODY></HTML> Thu, 11 Dec 2014 16:22:35 GMT amber2000 2014-12-11T16:22:35Z Calculate % based on parameter https://community.qlik.com/t5/QlikView/Calculate-based-on-parameter/m-p/817823#M1042155 <HTML><HEAD></HEAD><BODY><P>Hello Qlikview wizards,</P><P></P><P>I'm trying to calculate % based on a parameter.</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 392px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl63" height="17" style="border: 0.5pt solid gainsboro; width: 74pt; height: 12.75pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>WH_Cd</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Aisle_Desc</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Article_CW</STRONG></SPAN></TD><TD class="xl63" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: whitesmoke;" width="98"><SPAN style="color: #333333; font-family: Tahoma;"><STRONG>Sum_Colli</STRONG></SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl64" height="17" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; height: 12.75pt; background-color: whitesmoke;"><SPAN style="font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD class="xl64" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD class="xl64" style="border-width: 0px 0px 0.5pt; border-style: none none solid; border-color: black black gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG> </STRONG></SPAN></TD><TD align="right" class="xl65" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: black gainsboro gainsboro; background-color: whitesmoke;"><SPAN style="color: #000000; font-family: Tahoma;"><STRONG>370</STRONG></SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Traiteur</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">11</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">62</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">Y</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">152</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Zuivel</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD align="right" class="xl67" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">145</SPAN></TD></TR></TBODY></TABLE><P></P><P>The result I want is this (the last column represents the percentages):</P><TABLE border="0" cellpadding="0" cellspacing="0" jive-data-cell="{&quot;color&quot;:&quot;#575757&quot;,&quot;textAlign&quot;:&quot;left&quot;,&quot;padding&quot;:&quot;NaN&quot;,&quot;backgroundColor&quot;:&quot;#FFFFFF&quot;,&quot;fontFamily&quot;:&quot;arial,helvetica,sans-serif&quot;,&quot;verticalAlign&quot;:&quot;baseline&quot;}" jive-data-header="{&quot;color&quot;:&quot;#FFFFFF&quot;,&quot;backgroundColor&quot;:&quot;#6690BC&quot;,&quot;textAlign&quot;:&quot;center&quot;,&quot;padding&quot;:&quot;2&quot;}" style="width: 496px; border-collapse: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border: 0.5pt solid gainsboro; width: 74pt; height: 12.75pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 279.34px; background-color: white;" width="135"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">Y</SPAN></TD><TD class="xl68" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 74pt; background-color: white;" width="98"><SPAN style="color: #333333; font-family: Tahoma;">152</SPAN></TD><TD class="xl69" style="border-width: 0.5pt 0.5pt 0.5pt 0px; border-style: solid solid solid none; border-color: gainsboro gainsboro gainsboro #333333; width: 50pt; background-color: white;" width="67"><SPAN style="color: #333333; font-family: Tahoma;">41,08</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Vlees</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">62</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">16,76</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; height: 12.75pt; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">12</SPAN></TD><TD class="xl65" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">PBL_Zuivel + PBL_Traiteur</SPAN></TD><TD class="xl66" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">N</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">156</SPAN></TD><TD class="xl69" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">42,16</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border: 0px windowtext; height: 12.75pt; background-color: transparent;"></TD><TD style="border: 0px windowtext; background-color: transparent;"></TD><TD class="xl67" style="border: 0px windowtext; background-color: transparent;"></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt; border-style: none solid solid; border-color: #333333 gainsboro gainsboro; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">370</SPAN></TD><TD class="xl68" style="border-width: 0px 0.5pt 0.5pt 0px; border-style: none solid solid none; border-color: #333333 gainsboro gainsboro #333333; background-color: white;"><SPAN style="color: #333333; font-family: Tahoma;">100</SPAN></TD></TR></TBODY></TABLE><P></P><P>The expression</P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="; color: #ff0000; font-size: 8pt;"><STRONG>(</STRONG></SPAN><SPAN style="font-size: 8pt;">{$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Article_CW]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"Y"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">&gt;}/ </SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Article]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt; 99999"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[WH_Cd]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"12"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P>Wont work because I'm deviding two fields with the same result (370/ 370).</P><P></P><P>I'll attach this example in a qvw so it's easier to follow what I'm trying to accomplish.</P><P>Kind regards,</P><P>Ambertje</P></BODY></HTML> Thu, 11 Dec 2014 16:22:35 GMT https://community.qlik.com/t5/QlikView/Calculate-based-on-parameter/m-p/817823#M1042155 amber2000 2014-12-11T16:22:35Z Re: Calculate % based on parameter https://community.qlik.com/t5/QlikView/Calculate-based-on-parameter/m-p/817824#M1042156 <HTML><HEAD></HEAD><BODY><P>I managed to calculate the % with the Total function: </P><P>=<SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">[Article]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"&gt; 99999"</SPAN><SPAN style="font-size: 8pt;">}, </SPAN><SPAN style="color: #800000; font-size: 8pt;">[WH_Cd]</SPAN><SPAN style="font-size: 8pt;"> = {</SPAN><SPAN style="color: #800000; font-size: 8pt;">"12"</SPAN><SPAN style="font-size: 8pt;">}&gt;}</SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">)/</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">sum</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">TOTAL</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #800000; font-size: 8pt;">[#Colli]</SPAN><SPAN style="font-size: 8pt;">)) </SPAN></P><P> </P><P>The only thing that I can't fixe is to join the fields "PBL_Traiteur" and "PBL_Zuivel" together in this expression.</P><P>Can Someone please help me with this minor thing (but o so importent to me) please ???</P><P></P><P>Kind regards,</P><P>Ambertje</P></BODY></HTML> Thu, 11 Dec 2014 17:04:30 GMT https://community.qlik.com/t5/QlikView/Calculate-based-on-parameter/m-p/817824#M1042156 amber2000 2014-12-11T17:04:30Z