Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to create comparison between neighboring data on graph?

Hi!

I have trouble, which bother me for long time. I want compare two neighboring data on graph, which show sum of sale in given periods. I am using formula (sum of sale is my variable) =sum(sum of sale) / above(sum(sum of sale),rowno()-1), which works, but no in way I want - it compare every data to first value, not to nieghboring. I want to have different effect - the second value to first, the third to second etc. And it must be universal, because i want to filter months, according to my needs in some point of analysis. Can you help me? I'll be grateful.

1 Solution

Accepted Solutions
sunny_talwar

May be try this

Sum(sum of sale)/Above(Sum(sum of sale))

View solution in original post

2 Replies
sunny_talwar

May be try this

Sum(sum of sale)/Above(Sum(sum of sale))

Not applicable
Author

Yeah, of course, it works! Actually I've just overcomplicated it with this rowno. I think i did it because I want to have 100% on the first data, but to be honest it's not so important, so with your formula everything works smooth and I'm happy with this solution.

Thanks Sunny!