topic Re: Issue in Inputsum where it is showing null values in QlikView https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306792#M406653 <HTML><HEAD></HEAD><BODY><P>Check whether you have associated data with the dimension columns&nbsp; </P></BODY></HTML> Mon, 24 Apr 2017 13:12:11 GMT avinashelite 2017-04-24T13:12:11Z Issue in Inputsum where it is showing null values https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306791#M406652 <HTML><HEAD></HEAD><BODY><P>In a pivottable I have couple of expression and three dimension. Now in the third expression I am using Inputsum , but after using Inputsum(&lt;FieldName&gt;) I am getting lot of missing record and null values&nbsp; which was not expected. I tried with , if (Column(1)&gt;=0, 1,0)</P><P>as expression condition for that third expression but it is not working properly.</P></BODY></HTML> Mon, 24 Apr 2017 13:05:49 GMT https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306791#M406652 koushik_btech20 2017-04-24T13:05:49Z Re: Issue in Inputsum where it is showing null values https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306792#M406653 <HTML><HEAD></HEAD><BODY><P>Check whether you have associated data with the dimension columns&nbsp; </P></BODY></HTML> Mon, 24 Apr 2017 13:12:11 GMT https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306792#M406653 avinashelite 2017-04-24T13:12:11Z Re: Issue in Inputsum where it is showing null values https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306793#M406654 <HTML><HEAD></HEAD><BODY><P>Is there any chance to wrap Inputsum function by num function... because&nbsp; I saw after wrapping num(Inputsum(&lt;FieldName&gt;),'Numformat') it was not working... could any people share any idea..</P></BODY></HTML> Tue, 25 Apr 2017 09:01:29 GMT https://community.qlik.com/t5/QlikView/Issue-in-Inputsum-where-it-is-showing-null-values/m-p/1306793#M406654 koushik_btech20 2017-04-25T09:01:29Z