topic Re: Is it possible to surpress null value in a textbox? in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622035#M545090 <HTML><HEAD></HEAD><BODY><P>Many thanks Celambarasan Adhimulan, it Works!</P><P></P><P>For a side quastion - How does the *$ at the end, work in the set analysis ? </P></BODY></HTML> Thu, 10 Apr 2014 07:20:46 GMT 2014-04-10T07:20:46Z Is it possible to surpress null value in a textbox? https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622033#M545088 <HTML><HEAD></HEAD><BODY><P>Hi there, i hope someone can help me with my little problem.</P><P></P><P>Is is possible, like in the charts, to surpress null value for a dimension in a textbox?</P><P></P><P>I would like to surpress/remove the pink values in the total sum of the pie chart in the text field.</P><P></P><P>Thanks<BR />Teis T.W.</P><P></P><P><IMG alt="1.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/56950_1.PNG.png" /></P><P><IMG alt="2.PNG.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/56954_2.PNG.png" /></P></BODY></HTML> Thu, 10 Apr 2014 06:53:12 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622033#M545088 2014-04-10T06:53:12Z Re: Is it possible to surpress null value in a textbox? https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622034#M545089 <HTML><HEAD></HEAD><BODY><P>Try something like</P><P>Sum({&lt;Hovedbranche={"*"}&gt;*$} Oms)</P></BODY></HTML> Thu, 10 Apr 2014 06:57:45 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622034#M545089 CELAMBARASAN 2014-04-10T06:57:45Z Re: Is it possible to surpress null value in a textbox? https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622035#M545090 <HTML><HEAD></HEAD><BODY><P>Many thanks Celambarasan Adhimulan, it Works!</P><P></P><P>For a side quastion - How does the *$ at the end, work in the set analysis ? </P></BODY></HTML> Thu, 10 Apr 2014 07:20:46 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622035#M545090 2014-04-10T07:20:46Z Re: Is it possible to surpress null value in a textbox? https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622036#M545091 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">It results you the Intersection between the selection($) and the set analysis conditions.</SPAN></P><P></P><P>Just it will make the chart to work if any selection made on that field also. If you didn't use that then selection in the field Hovedbranche will be ignored.</P></BODY></HTML> Thu, 10 Apr 2014 09:33:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-surpress-null-value-in-a-textbox/m-p/622036#M545091 CELAMBARASAN 2014-04-10T09:33:06Z