topic Calculating Null values in QlikView https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157007#M377348 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table which contains values in dimension fields as ' - ' and it has values against it like $234 , $567... i want to add these values with other fields</P><P></P><P>would appreciate if anyone can help me with the expression.</P></BODY></HTML> Thu, 14 Jul 2016 10:07:09 GMT pipuindia99 2016-07-14T10:07:09Z Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157007#M377348 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a table which contains values in dimension fields as ' - ' and it has values against it like $234 , $567... i want to add these values with other fields</P><P></P><P>would appreciate if anyone can help me with the expression.</P></BODY></HTML> Thu, 14 Jul 2016 10:07:09 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157007#M377348 pipuindia99 2016-07-14T10:07:09Z Re: Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157008#M377349 <HTML><HEAD></HEAD><BODY><P>Which other fields you want to add it to?</P></BODY></HTML> Thu, 14 Jul 2016 10:15:19 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157008#M377349 sunny_talwar 2016-07-14T10:15:19Z Re: Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157009#M377350 <HTML><HEAD></HEAD><BODY><P>Thanks Sunny,</P><P></P><P>I got the solution, appreciate your quick response.</P></BODY></HTML> Thu, 14 Jul 2016 10:28:24 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157009#M377350 pipuindia99 2016-07-14T10:28:24Z Re: Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157010#M377351 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>You have to create an another dimension by specifying some text (Null) to the blank and than you can write the expression based on this dimension.</P></BODY></HTML> Thu, 14 Jul 2016 10:28:32 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157010#M377351 makrishnaraj 2016-07-14T10:28:32Z Re: Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157011#M377352 <HTML><HEAD></HEAD><BODY><P>No problem... I am glad you were able to figure it out. Please close this thread by marking Assumed Answer now.</P><P></P><P>Best,</P><P>Sunny</P></BODY></HTML> Thu, 14 Jul 2016 10:30:50 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157011#M377352 sunny_talwar 2016-07-14T10:30:50Z Re: Calculating Null values https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157012#M377353 <HTML><HEAD></HEAD><BODY><P>Hi prabhu,</P><P>You can try this,</P><P><STRONG>Sum({&lt;<SPAN style="color: #ff0000;">Dimension</SPAN>=&gt;}SalesAmount)</STRONG></P></BODY></HTML> Thu, 14 Jul 2016 10:49:17 GMT https://community.qlik.com/t5/QlikView/Calculating-Null-values/m-p/1157012#M377353 susovan 2016-07-14T10:49:17Z