topic expression help in QlikView https://community.qlik.com/t5/QlikView/expression-help/m-p/555512#M1124605 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Hoping for some help. I rasied a question a while ago for help with a calculation. I was kindly provided with the following expression to calculate decency. It workes, in that it provided a figure and matches at an overall level; however, when I then click our neighbourhood filter it doesn't then match the detail:</SPAN></P><P> </P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><SPAN style="color: #0000ff;">Num</SPAN>(<SPAN style="color: #0000ff;">Count</SPAN> ({&lt;<SPAN style="color: #800000;">[Decency]</SPAN>= {Decent}&gt;} <SPAN style="color: #800000;">[Decency]</SPAN>)/ <SPAN style="color: #0000ff;">Count</SPAN>({1} <SPAN style="color: #800000;">[Decency]</SPAN>), '#,##0.00%')&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">So to clarify when looking at figures overall the expression below matches the detail:</SPAN></P><P> </P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif; text-decoration: underline;">Overall</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;"><STRONG>Decency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % </STRONG></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4376&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30.01%</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Non decnt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 199&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.36%</SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Potnetially Non Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68.63%</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">However, when selecting a neighbourhood no longer works:</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">In Monton and Ellesmere we have the following breakdown; however, the expression above gives us a figure of 0.77%:</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;"><STRONG>Decency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % </STRONG></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 112&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18.54%</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Non decnt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.61%</SPAN></P><P><SPAN><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Potnetially Non Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 440&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72.85%</SPAN></SPAN></P><P> </P><P><SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">...?</SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:12:52 GMT 2014-01-06T09:12:52Z expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555512#M1124605 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Hi,</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Hoping for some help. I rasied a question a while ago for help with a calculation. I was kindly provided with the following expression to calculate decency. It workes, in that it provided a figure and matches at an overall level; however, when I then click our neighbourhood filter it doesn't then match the detail:</SPAN></P><P> </P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><SPAN style="color: #0000ff;">Num</SPAN>(<SPAN style="color: #0000ff;">Count</SPAN> ({&lt;<SPAN style="color: #800000;">[Decency]</SPAN>= {Decent}&gt;} <SPAN style="color: #800000;">[Decency]</SPAN>)/ <SPAN style="color: #0000ff;">Count</SPAN>({1} <SPAN style="color: #800000;">[Decency]</SPAN>), '#,##0.00%')&nbsp; </SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">So to clarify when looking at figures overall the expression below matches the detail:</SPAN></P><P> </P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif; text-decoration: underline;">Overall</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;"><STRONG>Decency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % </STRONG></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4376&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 30.01%</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Non decnt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 199&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1.36%</SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Potnetially Non Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10009&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 68.63%</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">However, when selecting a neighbourhood no longer works:</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">In Monton and Ellesmere we have the following breakdown; however, the expression above gives us a figure of 0.77%:</SPAN></P><P></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;"><STRONG>Decency&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Count&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; % </STRONG></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 112&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 18.54%</SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif; font-size: 10pt;">Non decnt&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 52&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 8.61%</SPAN></P><P><SPAN><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Potnetially Non Decent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 440&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 72.85%</SPAN></SPAN></P><P> </P><P><SPAN style="font-family: 'Calibri','sans-serif'; font-size: 11pt; mso-ascii-theme-font: minor-latin; mso-fareast-font-family: Calibri; mso-fareast-theme-font: minor-latin; mso-hansi-theme-font: minor-latin; mso-bidi-font-family: 'Times New Roman'; mso-bidi-theme-font: minor-bidi; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">...?</SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:12:52 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555512#M1124605 2014-01-06T09:12:52Z Re: expression help https://community.qlik.com/t5/QlikView/expression-help/m-p/555513#M1124606 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Hi Chris,</SPAN></P><P><SPAN style="color: #0000ff; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><SPAN style="color: #0000ff;">Count</SPAN>({1} <SPAN style="color: #800000;">[Decency]&nbsp; will give always the full count of decency.</SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">If you want it to work with selection use&nbsp; <SPAN style="font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><SPAN style="color: #0000ff;">Count</SPAN>(total <SPAN style="color: #800000;">[Decency] )</SPAN></SPAN></SPAN></P><P><SPAN style="color: #800000; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;"><BR /></SPAN></P><P><SPAN style="color: #800000; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">best regards</SPAN></P><P><SPAN style="color: #800000; font-size: 10pt; font-family: calibri, verdana, arial, sans-serif;">Chris<BR /></SPAN></P></BODY></HTML> Mon, 06 Jan 2014 09:16:11 GMT https://community.qlik.com/t5/QlikView/expression-help/m-p/555513#M1124606 2014-01-06T09:16:11Z