topic Re: Value not showing in QlikView https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426164#M513095 <HTML><HEAD></HEAD><BODY><P>Some selections are filtering out your values</P></BODY></HTML> Wed, 27 Sep 2017 14:06:42 GMT Clever_Anjos 2017-09-27T14:06:42Z Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426159#M513090 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have field called SalesValue and it has data. But when i try to do sum like Sum(SalesValue) it is showing as 0(zero) even thought i have data for the SalesValue column.</P><P></P><P>Any idea what is the issue. Attached is the screenshot for your reference.</P><P></P><P>Regards,</P><P>Viresh</P><P><IMG alt="Value not showing.PNG" class="jive-image image-1" src="/legacyfs/online/177890_Value not showing.PNG" style="height: auto;" />h</P></BODY></HTML> Wed, 27 Sep 2017 13:34:20 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426159#M513090 vireshkolagimat 2017-09-27T13:34:20Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426160#M513091 <HTML><HEAD></HEAD><BODY><P>All values seems to be unrelated to your application.</P><P>Maybe there´s a filter that is beeing applyied</P></BODY></HTML> Wed, 27 Sep 2017 13:47:09 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426160#M513091 Clever_Anjos 2017-09-27T13:47:09Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426161#M513092 <HTML><HEAD></HEAD><BODY><P>You data is formatted as Text, try </P><P>SUM(TRIM(Salesvalue))</P></BODY></HTML> Wed, 27 Sep 2017 13:47:32 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426161#M513092 vinieme12 2017-09-27T13:47:32Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426162#M513093 <HTML><HEAD></HEAD><BODY><P>Hi, If i make selections in listbox it shows the sum value. </P></BODY></HTML> Wed, 27 Sep 2017 13:58:55 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426162#M513093 vireshkolagimat 2017-09-27T13:58:55Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426163#M513094 <HTML><HEAD></HEAD><BODY><P>Hi, I tried but no changes. Thank you.</P></BODY></HTML> Wed, 27 Sep 2017 13:59:23 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426163#M513094 vireshkolagimat 2017-09-27T13:59:23Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426164#M513095 <HTML><HEAD></HEAD><BODY><P>Some selections are filtering out your values</P></BODY></HTML> Wed, 27 Sep 2017 14:06:42 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426164#M513095 Clever_Anjos 2017-09-27T14:06:42Z Re: Value not showing https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426165#M513096 <HTML><HEAD></HEAD><BODY><P>Hi Viresh,</P><P>Try:</P><P></P><P>=Sum(alt(SalesValue,0))</P><P></P><P>Cheers</P><P></P><P>Andrew</P></BODY></HTML> Wed, 27 Sep 2017 14:11:17 GMT https://community.qlik.com/t5/QlikView/Value-not-showing/m-p/1426165#M513096 effinty2112 2017-09-27T14:11:17Z