Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
soniasweety
Valued Contributor III

Line chart

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

1 Solution

Accepted Solutions
Highlighted

Re: Line chart

My bad, try this:

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

Capture.PNG

View solution in original post

8 Replies
Highlighted
Not applicable

Re: Line chart

Hi Sony,

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

How do you want the month comparison.

Highlighted

Re: Line chart

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

Highlighted
soniasweety
Valued Contributor III

Re: Line chart

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

Highlighted
soniasweety
Valued Contributor III

Re: Line chart

Month comparison.

Highlighted

Re: Line chart

Do you need this?

Capture.PNG

Highlighted
soniasweety
Valued Contributor III

Re: Line chart

No sunny.

1203-800

901-1002

604-605

like that

Highlighted

Re: Line chart

My bad, try this:

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

Capture.PNG

View solution in original post

Highlighted
Not applicable

Re: Line chart

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