topic Re: How to Display Zero's on Line chart in QlikView

How to Display Zero's on Line chart

Anonymous — Mon, 10 Apr 2017 10:00:18 GMT

Hi All,

I have a line chart which had one Dimension and One expression. The chart is showing last 6 months data for example if I select Mar 2017 it will show Oct 2016 to Mar 2017 Data .According to Month selection it will display last 6 Months Data But the issue is this chart not showing '0' values for example Dec 2016 has value '0' this is not showing in chart. I already unchecked 'Suppress zero's' and checked 'Zeros on bar' but still not getting values. I tried to check 'Show All values' for Dimension but it is showing all years and months values.

Please help me to resolve this its an urgent issue in my project.

Thanks,

Anusha K

Re: How to Display Zero's on Line chart

Anil_Babu_Samineni — Mon, 10 Apr 2017 10:02:37 GMT

May be use Dimension level like Show All Values? Or would share sample

Re: How to Display Zero's on Line chart

Anonymous — Mon, 10 Apr 2017 10:07:33 GMT

I tried 'Show All values' it is showing All years data instead of last 6 months Data. I can't share sample because its a highly secured network.

Re: How to Display Zero's on Line chart

Anil_Babu_Samineni — Mon, 10 Apr 2017 10:12:26 GMT

Atleast Expression? And screen shot may be

Re: How to Display Zero's on Line chart

Anonymous — Mon, 10 Apr 2017 10:16:25 GMT

Dimension: Month_Year

Expression: = Median({<IncidentDate={">=$(=Num(MonthStart(AddMonths(Max(Incident_Date),-5))))<=$(=Num(Max(Incident_Date)))"},Month=,Year=,Impact={'1*','2*','3*'},Urgency={'1*','2*'},Month=,Year=>}[Incident Duration]) * 60

Re: How to Display Zero's on Line chart

Anil_Babu_Samineni — Mon, 10 Apr 2017 10:23:34 GMT

Does IncidentDate is associate to Month_Year? Because, Set analysis you are doing with two diff. Fields. May be use Month_Year instead of IncidentDate.

If so, From my end last chance please share data -- Scrambling Data

Re: How to Display Zero's on Line chart

Anonymous — Mon, 10 Apr 2017 11:18:15 GMT

Both dates are associated with Month_Year Field. If I use Month_Year instead of IncidentDate the result will be same no change in result.