topic Re: Show 0 for x-axis when there is no data in QlikView https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394125#M565829 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Okay, I understand your problem. I agree there should be a setting to allow this - continuous axis doesn't work as you need it - but as there isn't possibly the easiest way is to add the missing data to your tables in the load script. If this isn't possible, the following MIGHT work if the value is held in a table and not part of an aggregated value outside of the load script.</P><P></P><P>Use this as your dimension ...</P><P></P><P><STRONG>=ValueLoop(min(total ID),max(total ID))</STRONG></P><P></P><P>This will create a range from the smallest to largest value.&nbsp; You then need to create 4 expressions (although you could possible merge into one once full tested).</P><P></P><P>1. <STRONG>=FieldIndex('ID',ValueLoop(min(total ID),max(total ID))) </STRONG>- label as Index</P><P>2.<STRONG> =concat({1} NumValue,';',ID) </STRONG>- label as AllValues, where NumValue is the value to plot</P><P>3. <STRONG>=subfield(AllValues,';',Index) </STRONG>- label as IDValue</P><P>4. <STRONG>=If(IDValue&gt;0,IDValue,0) </STRONG>- final value to plot</P><P></P><P>You could then try to merge the expressions, or set the first three to invisible and max Axes to Max(NumValue).</P><P></P><P></P><P>flipside</P><P></P><P>EDIT:</P><P>The above is probably too complicated - you can do this instead in a single expression ...</P><P></P><P>COUNT:</P><P>=sum(IF(ID=ValueLoop(min(total ID),max(total ID)),1,0))</P><P></P><P>SUM:</P><P>=SUM(IF(ID=ValueLoop(min(total ID),max(total ID)),NumValue,0))</P></BODY></HTML> Mon, 03 Dec 2012 11:36:03 GMT flipside 2012-12-03T11:36:03Z Show 0 for x-axis when there is no data https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394122#M565826 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a huge list of data with a number of X</P><P>I have made the below graph to count the number of times X appears into Y.</P><P></P><P>Sometimes the count is 0, the graph will skip the number X with 0 count.</P><P></P><P>Is there anyway the show the all the value of the X axis between my highest and lowest X with count.<IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /></P><P><IMG __jive_id="25846" class="jive-image-thumbnail jive-image" height="151" onclick="" alt="qv_fill_in_the_blank.JPG" src="https://community.qlik.com/legacyfs/online/25846_qv_fill_in_the_blank.JPG" width="894" /></P></BODY></HTML> Fri, 30 Nov 2012 09:50:37 GMT https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394122#M565826 2012-11-30T09:50:37Z Re: Show 0 for x-axis when there is no data https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394123#M565827 <HTML><HEAD></HEAD><BODY><P>Try de-selecting "Suppress Zero-values" on presentation tab.</P><P></P><P></P><P>flipside</P></BODY></HTML> Fri, 30 Nov 2012 10:11:29 GMT https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394123#M565827 flipside 2012-11-30T10:11:29Z Re: Show 0 for x-axis when there is no data https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394124#M565828 <HTML><HEAD></HEAD><BODY><P>Tried.</P><P></P><P>It does not work as there is no value at all. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/plain.png" /></P></BODY></HTML> Mon, 03 Dec 2012 00:52:28 GMT https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394124#M565828 2012-12-03T00:52:28Z Re: Show 0 for x-axis when there is no data https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394125#M565829 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Okay, I understand your problem. I agree there should be a setting to allow this - continuous axis doesn't work as you need it - but as there isn't possibly the easiest way is to add the missing data to your tables in the load script. If this isn't possible, the following MIGHT work if the value is held in a table and not part of an aggregated value outside of the load script.</P><P></P><P>Use this as your dimension ...</P><P></P><P><STRONG>=ValueLoop(min(total ID),max(total ID))</STRONG></P><P></P><P>This will create a range from the smallest to largest value.&nbsp; You then need to create 4 expressions (although you could possible merge into one once full tested).</P><P></P><P>1. <STRONG>=FieldIndex('ID',ValueLoop(min(total ID),max(total ID))) </STRONG>- label as Index</P><P>2.<STRONG> =concat({1} NumValue,';',ID) </STRONG>- label as AllValues, where NumValue is the value to plot</P><P>3. <STRONG>=subfield(AllValues,';',Index) </STRONG>- label as IDValue</P><P>4. <STRONG>=If(IDValue&gt;0,IDValue,0) </STRONG>- final value to plot</P><P></P><P>You could then try to merge the expressions, or set the first three to invisible and max Axes to Max(NumValue).</P><P></P><P></P><P>flipside</P><P></P><P>EDIT:</P><P>The above is probably too complicated - you can do this instead in a single expression ...</P><P></P><P>COUNT:</P><P>=sum(IF(ID=ValueLoop(min(total ID),max(total ID)),1,0))</P><P></P><P>SUM:</P><P>=SUM(IF(ID=ValueLoop(min(total ID),max(total ID)),NumValue,0))</P></BODY></HTML> Mon, 03 Dec 2012 11:36:03 GMT https://community.qlik.com/t5/QlikView/Show-0-for-x-axis-when-there-is-no-data/m-p/394125#M565829 flipside 2012-12-03T11:36:03Z