topic Re: =(Column(2)-Column(4))/Column(5) is not working in the table in QlikView https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23176#M790780 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191884_Capture.PNG" style="height: 184px; width: 620px;" /></P></BODY></HTML> Tue, 30 Jan 2018 15:23:29 GMT sunny_talwar 2018-01-30T15:23:29Z =(Column(2)-Column(4))/Column(5) is not working in the table https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23174#M790778 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #000000;">Hi Experts,</SPAN></P><P></P><P><SPAN style="color: #000000;">Can any one please help me on this.</SPAN></P><P><SPAN style="color: #000000;">In the below table in the last column I have to calculate</SPAN></P><P></P><P><SPAN style="color: #000000;">=(Frequency-Mean)/SD</SPAN></P><P></P><P><SPAN style="color: #575757;"><SPAN style="color: #000000;">I have tried</SPAN> </SPAN><SPAN style="color: #ff0000;">=(Column(2)-Column(4))/Column(5) <SPAN style="color: #000000;">but getting all null values.</SPAN></SPAN></P><P><SPAN style="color: #000000;">How to get the expected result.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Please find the attached app.</SPAN></P><P></P><P></P><P><IMG __jive_id="191883" alt="column issue.png" class="jive-image image-1" src="/legacyfs/online/191883_column issue.png" style="height: 99px; width: 620px;" /></P><P>Thanks in advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23174#M790778 bhavvibudagam 2020-11-25T16:16:04Z Re: =(Column(2)-Column(4))/Column(5) is not working in the table https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23175#M790779 <HTML><HEAD></HEAD><BODY><P>You only have 4 expressions in your app... why are you using Column(5)?</P><P></P><P>Do you mean this?</P><P><STRONG>(Column(1) - Column(3))/Column(4)</STRONG></P></BODY></HTML> Tue, 30 Jan 2018 15:22:26 GMT https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23175#M790779 sunny_talwar 2018-01-30T15:22:26Z Re: =(Column(2)-Column(4))/Column(5) is not working in the table https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23176#M790780 <HTML><HEAD></HEAD><BODY><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/191884_Capture.PNG" style="height: 184px; width: 620px;" /></P></BODY></HTML> Tue, 30 Jan 2018 15:23:29 GMT https://community.qlik.com/t5/QlikView/Column-2-Column-4-Column-5-is-not-working-in-the-table/m-p/23176#M790780 sunny_talwar 2018-01-30T15:23:29Z