topic Re: Line chart in QlikView

Line chart

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

Hi Qlik,

I have data and i have created a line chart month wise.

but in that line chart i want to see other line which demonstrate month comparison

how to do this?

sample attached.

in my exmple

Re: Line chart

Tue, 06 Dec 2016 11:55:24 GMT

Hi Sony,

What difference (Month comparison) you want see in another line in the same graph.

How do you want the month comparison.

Re: Line chart

sunny_talwar — Tue, 06 Dec 2016 12:01:01 GMT

Year comparison or month comparison? How do you imagine to see this outside of QlikView?

Re: Line chart

soniasweety — Tue, 06 Dec 2016 12:01:11 GMT

hi,

i want to see the other line in the same chars month comparision

like i have data for jan,feb,mar, like that

i need jan-feb , mar-aprl, may-jun, ...... i need this in other line

Re: Line chart

soniasweety — Tue, 06 Dec 2016 12:07:50 GMT

Month comparison.

Re: Line chart

sunny_talwar — Tue, 06 Dec 2016 12:07:54 GMT

Do you need this?

Re: Line chart

soniasweety — Tue, 06 Dec 2016 12:12:15 GMT

No sunny.

1203-800

901-1002

604-605

like that

Re: Line chart

sunny_talwar — Tue, 06 Dec 2016 12:16:50 GMT

My bad, try this:

Above(Sum(sales)) - Sum(sales)

Re: Line chart

Tue, 06 Dec 2016 12:16:57 GMT

You are using month as your dimension, but you want difference (Two months comparison).

i think it is some tricky because your month dimension is getting populated and displayed based on your sales, again on the top of your month you want to compare two months sales on single month dimension.

Please correct me if i miss anything