topic Set Expression in QlikView https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1284369#M402319 <HTML><HEAD></HEAD><BODY><P>I have following set expression in QV Document</P><P>=fabs((Sum({&lt;SECTOR={"COLOMBO"}&gt;}ACTUAL)/$(=$(=vActual))))</P><P></P><P>This is working well and I Want to modify it to include sector in 2nd part of expression as follows</P><P></P><P>=fabs((Sum({&lt;SECTOR={"COLOMBO"}&gt;}ACTUAL)/$(=$<SPAN style="color: #ff0000; font-size: 13.3333px;">{&lt;SECTOR={"COLOMBO"}&gt;</SPAN>(=vCact))))</P><P></P><P>Then it does not work . Can you pls help me to correct it</P></BODY></HTML> Fri, 20 Jan 2017 07:50:42 GMT upaliwije 2017-01-20T07:50:42Z Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1284369#M402319 <HTML><HEAD></HEAD><BODY><P>I have following set expression in QV Document</P><P>=fabs((Sum({&lt;SECTOR={"COLOMBO"}&gt;}ACTUAL)/$(=$(=vActual))))</P><P></P><P>This is working well and I Want to modify it to include sector in 2nd part of expression as follows</P><P></P><P>=fabs((Sum({&lt;SECTOR={"COLOMBO"}&gt;}ACTUAL)/$(=$<SPAN style="color: #ff0000; font-size: 13.3333px;">{&lt;SECTOR={"COLOMBO"}&gt;</SPAN>(=vCact))))</P><P></P><P>Then it does not work . Can you pls help me to correct it</P></BODY></HTML> Fri, 20 Jan 2017 07:50:42 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1284369#M402319 upaliwije 2017-01-20T07:50:42Z Re: Set Expression https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1284370#M402320 <HTML><HEAD></HEAD><BODY><P>What does the vActual &amp; vCact here?</P></BODY></HTML> Fri, 20 Jan 2017 08:40:45 GMT https://community.qlik.com/t5/QlikView/Set-Expression/m-p/1284370#M402320 Anil_Babu_Samineni 2017-01-20T08:40:45Z