topic Line chart in QlikView

Line chart

Anonymous — Mon, 17 Aug 2015 17:27:45 GMT

I have one line in my chart to show count of usage that is high during that hour,minute etc.But in case of zero values line chart doesnt come to zero, i tried if expression result zero than zero else expression, but still line chart dint show for null values. any other way is it possible?

Re: Line chart

ramoncova06 — Mon, 17 Aug 2015 17:29:35 GMT

did you unchecked the suppress zeros from the presentation tab ?

are they zeros or nulls ?

Re: Line chart

Anonymous — Mon, 17 Aug 2015 17:33:06 GMT

Hi,

Could you please upload sample app.

Re: Line chart

Anonymous — Mon, 17 Aug 2015 18:20:26 GMT

Yes i unchecked ...no data available in data file for those particular axis.............for exp for 0 hour 1 hour usage of high measure is not entered in data file

Re: Line chart

ramoncova06 — Mon, 17 Aug 2015 18:34:56 GMT

so then it means you have null data, QV is not going to show anything for it since the data does not exist

might be worth creating a master calendar with hours, this way you can look for entries with a null value another option would be add a row with a zero value for that specific period, this seems simple but you have to take into consideration if you are doing counts as this could skew those numbers