topic Re: Line Chart Help in QlikView

Line Chart Help

greend21 — Wed, 25 Nov 2020 16:16:04 GMT

I have a table in excel that is being loaded into Qlikview and recreated as a pivot. I also wanted to make a line chart out of this, but for some reason get stumped on charts. I am also not sure it can be done with the data like this.

Month (1), 2, 3, etc are each a dimension in Qlikview. I would like all of these across the bottom of the chart with a trend line for each Bill Sys Cd. I also need each month to add to the previous month, so month 2 would show 4.5% and month 3 would show 9.6% and so on so it would like like the chart below. I think this is selecting full accumulation?

Any tips for this?

Re: Line Chart Help

Anonymous — Fri, 16 Feb 2018 18:57:31 GMT

Is this what you are looking for?

Re: Line Chart Help

greend21 — Fri, 16 Feb 2018 19:20:10 GMT

Yes, exactly what I am looking for. Thank you!

Re: Line Chart Help

Anonymous — Fri, 16 Feb 2018 19:26:59 GMT

You are welcome

Re: Line Chart Help

shiveshsingh — Sat, 17 Feb 2018 03:19:20 GMT

Good one

Re: Line Chart Help

greend21 — Mon, 19 Feb 2018 17:57:02 GMT

I have another question. Based on the sample data below, the purple line stops because the pivot is seeing month's 8-10 as missing values. Do you have any idea how I can ge these recognized as numberic 0's and if so, will the line continue with the full accumulation set? I've tried some If statements with IsNull(field) or leng(trim(field)) = 0 but nothing has worked so far.