topic Re: Line Chart in QlikView

Line Chart

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

Hello

I want to create a line chart with the data I have like- 'Date column' which is having dates from May to Sep(Format :5/11/2017-9/31/2017) and other column I have is 'Overdue' which contains numbers like- 1,2,3,4,5 with repetition.

So I want to calculate -how many are 5's in 'Over due' for particular month( Suppose May) /how many are overall numbers(1,2,3,4,5) like wise each month I need to calculate and create line chart. I took dimension as date column and in Expression how to write to achieve the above scenario. Please help me out as soon as possible. Thanks!

Re: Line Chart

prabhu0505 — Wed, 18 Sep 2019 20:27:12 GMT

if possible share app with sample data

Re: Line Chart

Victor_Alumanah — Thu, 19 Sep 2019 10:11:41 GMT

Hi Pujitha,

I would recomend a bar chart as a line chart could get messy very quickly.

1. Create a bar chart

2. add calculated dimension =MONTH([Date Column])

3. add dimension Overdue

4. add expression =Count(Overdue)

5. If you want to change the style, go to the style tab and select Stacked

Thanks

Victor

Re: Line Chart

Pujitha — Thu, 19 Sep 2019 13:50:02 GMT

Data sample:

Need to calculate in line chart how many are 5's divided by how many are (1's,2's,3's,4's) in may month, June onth july month The graph I need to get like this. Please advice me as soon as possible.

Re: Line Chart

Pujitha — Thu, 19 Sep 2019 13:58:05 GMT

Data sample:

Date Overdue

07/22/2017 1

07/23/2017 2

07/24/2017 3

07/28/2017 5

08/23/2017 5

08/25/2017 3

09/20/2017 2

09/11/2017 5

Need to calculate in line chart how many are 5's divided by how many are (1's,2's,3's,4's) in may month, June month, July month The graph I need to get like:

horizantal x-axis will be may june july month y axis will be the scale from 0 to 3, The line chart should come. Please suggest me good approach

Re: Line Chart

Victor_Alumanah — Thu, 19 Sep 2019 14:13:39 GMT

I think it may be a bit difficult to understand without seeing a sample of what you are trying to do. The initial solution I posted can be changed to a line graph, and then add "Overdue" to the dimensions and then you have your lines. I don't understand the part you mentioned about dividing 5 by the other numbers.