topic Re: Charts showing null in QlikView https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426269#M819453 <HTML><HEAD></HEAD><BODY><P>If you use expression <SPAN style="font-family: 'courier new', courier;"><SPAN style="color: #0000ff;">Sum(InventoryQty*[Unit Cost])</SPAN>,<SPAN style="font-family: calibri, verdana, arial, sans-serif;"> you get</SPAN></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174025_Capture.PNG" style="height: auto;" /></SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">and what do you expect to see?</SPAN></P></BODY></HTML> Mon, 21 Aug 2017 09:15:55 GMT tresB 2017-08-21T09:15:55Z Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426261#M819445 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>I have been facing this issue where I have to display an Inventory Value against a particular Brand but the bar chart does not plot anything. (No data to display).</P><P></P><P>My Dimension column contains <STRONG>Brand</STRONG> and in the Expressions I just add <STRONG>(Inventory Qty * Cost).&nbsp; </STRONG>Somehow the Graph does not display anything. Whereas, when I change my Dimension from Brand to SKU the chart displays something (even if that is not the result i want).</P><P></P><P>I'm sure I am missing something here. What am I doing wrong</P><P></P><P>Thanks in advance,</P><P>Siddhesh</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426261#M819445 siddheshmane 2020-11-25T16:16:04Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426262#M819446 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Maybe expression <STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(<SPAN style="color: #ff0000;">[</SPAN>Inventory Qty<SPAN style="color: #ff0000;">]</SPAN> * Cost)</STRONG></P></BODY></HTML> Fri, 18 Aug 2017 12:21:41 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426262#M819446 ahaahaaha 2017-08-18T12:21:41Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426263#M819447 <HTML><HEAD></HEAD><BODY><P>Hi, try Sum<STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">(</STRONG>Inventory Qty * Cost) as your measure.</P><P></P><P>Regards,</P><P></P><P>Caio</P></BODY></HTML> Fri, 18 Aug 2017 12:22:01 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426263#M819447 caio_caminoski 2017-08-18T12:22:01Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426264#M819448 <HTML><HEAD></HEAD><BODY><P>Also, andrey is right, try </P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Sum</SPAN><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">([</STRONG><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Inventory Qty] * Cost)</SPAN></P></BODY></HTML> Fri, 18 Aug 2017 12:22:54 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426264#M819448 caio_caminoski 2017-08-18T12:22:54Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426265#M819449 <HTML><HEAD></HEAD><BODY><P>Thank you for helping me out here. </P><P>I tried doing SUM but the Inventory Value goes waay beyond actual.. </P><P>SUM gives me axis of 35,000,000</P><P>whereas it should actually be around 40,000-50,000</P></BODY></HTML> Fri, 18 Aug 2017 12:31:46 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426265#M819449 siddheshmane 2017-08-18T12:31:46Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426266#M819450 <HTML><HEAD></HEAD><BODY><P>Can we see a fragment of your data?</P></BODY></HTML> Fri, 18 Aug 2017 12:36:07 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426266#M819450 ahaahaaha 2017-08-18T12:36:07Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426267#M819451 <HTML><HEAD></HEAD><BODY><P>The correct formula depends on your datamodel.</P><P>Could you print your datamodel?</P></BODY></HTML> Fri, 18 Aug 2017 12:40:47 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426267#M819451 Clever_Anjos 2017-08-18T12:40:47Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426268#M819452 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>Apologies for the delay, Please find below QV file</P><P></P><P>Thank you</P></BODY></HTML> Mon, 21 Aug 2017 09:02:53 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426268#M819452 siddheshmane 2017-08-21T09:02:53Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426269#M819453 <HTML><HEAD></HEAD><BODY><P>If you use expression <SPAN style="font-family: 'courier new', courier;"><SPAN style="color: #0000ff;">Sum(InventoryQty*[Unit Cost])</SPAN>,<SPAN style="font-family: calibri, verdana, arial, sans-serif;"> you get</SPAN></SPAN></P><P><SPAN style="font-family: calibri, verdana, arial, sans-serif;"><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/174025_Capture.PNG" style="height: auto;" /></SPAN></P><P><SPAN style="font-family: arial, helvetica, sans-serif;">and what do you expect to see?</SPAN></P></BODY></HTML> Mon, 21 Aug 2017 09:15:55 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426269#M819453 tresB 2017-08-21T09:15:55Z Re: Charts showing null https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426270#M819454 <HTML><HEAD></HEAD><BODY><P>Thank you for your advice,</P><P>I tried using this expression. but the user said that the value isn't supposed to exceed 100000. Am i doing something wrong?</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 21 Aug 2017 12:54:57 GMT https://community.qlik.com/t5/QlikView/Charts-showing-null/m-p/1426270#M819454 siddheshmane 2017-08-21T12:54:57Z