Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

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
sunny_talwar

My bad, try this:

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

Capture.PNG

View solution in original post

8 Replies
Not applicable

Hi Sony,

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

How do you want the month comparison.

sunny_talwar

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

soniasweety
Master
Master
Author

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

soniasweety
Master
Master
Author

Month comparison.

sunny_talwar

Do you need this?

Capture.PNG

soniasweety
Master
Master
Author

No sunny.

1203-800

901-1002

604-605

like that

sunny_talwar

My bad, try this:

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

Capture.PNG

Not applicable

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