topic supress zero or null value in QlikView https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196229#M56397 <HTML><HEAD></HEAD><BODY><P>Hey ,</P><P>yess....</P></BODY></HTML> Mon, 04 Apr 2011 08:33:42 GMT 2011-04-04T08:33:42Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196224#M56392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I have a bar cart with 2 series and i want to show the vaue of first series just for last selected dimetions... for example dimention is year and expressions are plan and turn over.... and i want to show plan for all selected year and show just last year turn over...</P><P>can you help me?</P></BODY></HTML> Sun, 03 Apr 2011 11:52:37 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196224#M56392 2011-04-03T11:52:37Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196225#M56393 <HTML><HEAD></HEAD><BODY><P>Can you post a sample, so that we can understand better and help you solve it</P><P></P></BODY></HTML> Sun, 03 Apr 2011 21:31:09 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196225#M56393 2011-04-03T21:31:09Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196226#M56394 <HTML><HEAD></HEAD><BODY><P>Hey Hi,</P><P>In this case you can perform the following steps:</P><P>1.Keep the Expression for 'plan' as it, i.e. no need to change anything in that.</P><P>2.In the expression for 'turn over' use set analysis as</P><P></P><BLOCKQUOTE style="overflow-x: scroll;"><PRE style="margin: 0px;"><BR />sum({&lt;Year={$(=max(Year))}&gt;} TurnOver)<BR /></PRE></BLOCKQUOTE><BR /><BR /> <P>This will show the turn over for the maximum year, even in the selections.</P><P>3.Check the check box 'Suppress Null Values' in the Dimention tab.</P><P></P><P>Hope this works....</P><P></P><P></P></BODY></HTML> Mon, 04 Apr 2011 07:48:33 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196226#M56394 rahulgupta 2011-04-04T07:48:33Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196227#M56395 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>tanx for your help.... In this case as you see for the blue seies we see zero value... I want eleminate blue one for all years exept last year...</P><P><A href="http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/6825.untitled.bmp"><IMG alt="" border="0" src="http://community.qlik.com/resized-image.ashx/__size/550x0/__key/CommunityServer.Discussions.Components.Files/11/6825.untitled.bmp" /></A></P><P>thanxx</P></BODY></HTML> Mon, 04 Apr 2011 07:57:31 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196227#M56395 2011-04-04T07:57:31Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196228#M56396 <HTML><HEAD></HEAD><BODY><P>Hi S.</P><P>Did you try the option "Supress When Value is Null" ?<BR />It's on your Dimension tab @ settings for seleceted dimension.</P><P></P></BODY></HTML> Mon, 04 Apr 2011 08:00:32 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196228#M56396 Anonymous 2011-04-04T08:00:32Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196229#M56397 <HTML><HEAD></HEAD><BODY><P>Hey ,</P><P>yess....</P></BODY></HTML> Mon, 04 Apr 2011 08:33:42 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196229#M56397 2011-04-04T08:33:42Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196230#M56398 <HTML><HEAD></HEAD><BODY><P>Yess... It's the answer or Yess.. you tried? <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span></P></BODY></HTML> Mon, 04 Apr 2011 08:55:18 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196230#M56398 Anonymous 2011-04-04T08:55:18Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196231#M56399 <HTML><HEAD></HEAD><BODY><P>Hi Dennis</P><P><span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> I tried but dont get answer....</P><P>thanx dear;)</P></BODY></HTML> Mon, 04 Apr 2011 09:02:43 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196231#M56399 2011-04-04T09:02:43Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196232#M56400 <HTML><HEAD></HEAD><BODY><P>Did you also tried this on the Presentation Tab?</P><P>There it is called : Supress Zero-Values</P></BODY></HTML> Mon, 04 Apr 2011 09:16:41 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196232#M56400 Anonymous 2011-04-04T09:16:41Z supress zero or null value https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196233#M56401 <HTML><HEAD></HEAD><BODY><P>Dennis</P><P>it is working:-) i change chart type from bar chart to line and bar chart and it is done <span class="lia-unicode-emoji" title=":winking_face:">😉</span></P><P>thanxxxx</P></BODY></HTML> Mon, 04 Apr 2011 10:45:28 GMT https://community.qlik.com/t5/QlikView/supress-zero-or-null-value/m-p/196233#M56401 2011-04-04T10:45:28Z