topic Re: qlikview script or chat expression needed. in QlikView https://community.qlik.com/t5/QlikView/qlikview-script-or-chat-expression-needed/m-p/2552182#M1334863 <P>Hi, it's very hard to follow the requirements, have you read it and you can follow it?</P><P>From the output required chart maybe you need:</P><P>- Test1: If(Test1=Column4, Test1)</P><P>- Test2: If(Test2=Column4, Test2)</P> Fri, 26 Jun 2026 13:08:41 GMT rubenmarin 2026-06-26T13:08:41Z qlikview script or chat expression needed. https://community.qlik.com/t5/QlikView/qlikview-script-or-chat-expression-needed/m-p/2552091#M1334861 <P>INPUT:</P><P>Column1</P><P>Column2</P><P>Column3</P><P>Column4</P><P>Test1</P><P>Test2</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>-</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>-</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>-</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>-</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>-</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>6119057850</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>-</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>-</P><P>6119057850</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>-</P><P>6119057850</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>-</P><P>6119057850</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>-</P><P>6119057850</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>-</P><P>6119057850</P><P>&nbsp;</P><P>&nbsp;</P><P>OUTPUT REQUIRED FOR CHART EXPRESSION IN QLIKVIEW:</P><P>&nbsp;</P><P>Column1</P><P>Column2</P><P>Column3</P><P>Column4</P><P>Test1</P><P>Test2</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057848</P><P>6119057848</P><P>6119057848</P><P>2855791</P><P>40309730</P><P>446057</P><P>6119057850</P><P>6119057850</P><P>6119057850</P><P>&nbsp;</P><P>Till column 4 data from Table1,&nbsp; column1 , column2,column3 taken as key from Table 1 , Table2, Table3.</P><P>column4 value should match with Test1,Test2 or can be null. Table 2 and Table3 one <FONT color="#FF6600">field name</FONT> is similar which contains the above values mentioned in the Test1 teast2. Alias <FONT color="#FF6600">field name1</FONT> &amp; <FONT color="#FF6600">field name2</FONT>&nbsp;</P><P>From Table 2 :Tast1 chart condition applied : if (sum(num( column4)=sum(num(<FONT color="#FF6600">field name1</FONT>),field name1)&nbsp;</P><P>From Table3 :Tast2 chart condition applied : if (sum(num( column4)=sum(num(f<FONT color="#FF6600">field name2</FONT><SPAN>,field name2)&nbsp;</SPAN></P><P>&nbsp;I just wanted to show the missing value in the test1 and test2 corresponding to column4</P> Thu, 25 Jun 2026 14:23:25 GMT https://community.qlik.com/t5/QlikView/qlikview-script-or-chat-expression-needed/m-p/2552091#M1334861 sivavasam 2026-06-25T14:23:25Z Re: qlikview script or chat expression needed. https://community.qlik.com/t5/QlikView/qlikview-script-or-chat-expression-needed/m-p/2552182#M1334863 <P>Hi, it's very hard to follow the requirements, have you read it and you can follow it?</P><P>From the output required chart maybe you need:</P><P>- Test1: If(Test1=Column4, Test1)</P><P>- Test2: If(Test2=Column4, Test2)</P> Fri, 26 Jun 2026 13:08:41 GMT https://community.qlik.com/t5/QlikView/qlikview-script-or-chat-expression-needed/m-p/2552182#M1334863 rubenmarin 2026-06-26T13:08:41Z