topic divide operation -Please Help in QlikView https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231445#M83189 <HTML><HEAD></HEAD><BODY><P>Hi Karl Pover,</P><P></P><P>Thank you very much !</P><P></P><P>Best Regards,</P></BODY></HTML> Thu, 07 Oct 2010 18:52:49 GMT 2010-10-07T18:52:49Z divide operation -Please Help https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231443#M83187 <HTML><HEAD></HEAD><BODY><P>Hi together,</P><P>please look at my attached example qvw file.</P><P>I have three fields "a", "b" and "complete". At the beginning i have the field "complete" with the sum of the fileds "b". In this case it is</P><P>complete = sum ( total ( b ) ) ; like 20+20+30+30+30+40+50 = 220. ok, so far so good !</P><P>Now If i choice at the field "a" the option "bmw", then they select the assigned value of 20 from field "b". When i do that, the "complete" field also changed to the assigned value "20".</P><P>But my goal is, to divide the sum 220 with the selected value 20. So that i get the value 10.</P><P></P><P>How can i do that. Thank you !</P><P></P></BODY></HTML> Thu, 07 Oct 2010 18:26:58 GMT https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231443#M83187 2010-10-07T18:26:58Z divide operation -Please Help https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231444#M83188 <HTML><HEAD></HEAD><BODY><P>You have to ignore the selection of "a" with set analysis:</P><P>= sum ( {$&lt;a=&gt;} total (b) )</P><P>Regards.</P></BODY></HTML> Thu, 07 Oct 2010 18:49:44 GMT https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231444#M83188 pover 2010-10-07T18:49:44Z divide operation -Please Help https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231445#M83189 <HTML><HEAD></HEAD><BODY><P>Hi Karl Pover,</P><P></P><P>Thank you very much !</P><P></P><P>Best Regards,</P></BODY></HTML> Thu, 07 Oct 2010 18:52:49 GMT https://community.qlik.com/t5/QlikView/divide-operation-Please-Help/m-p/231445#M83189 2010-10-07T18:52:49Z