Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Pedro_Rodriguez
Contributor III
Contributor III

Chart including relative values evolution

Hi all,

I'm trying to get something like this:

Captura.JPG

Let's say I have sales and months, and I want a line&bar chart with the sales in the bars and the difference between month-past mont in the line as can be seen in the image. I'm aware is very difficult to get the values halfway through 2 dimensions, that's not important, they can be shown as values from the line expression.

Other requirement I have is if I select 2 months, the line value should reflect the difference between those 2 months; and if I have only one month selected it will show 0 (no evolution in that month)

Attached is an example with some data for testing

Thanks a lot in advance!

1 Solution

Accepted Solutions
Sergey_Shuklin
Specialist
Specialist

Hello!

Use Above() function and some cosmetical hints. You can find some at the attachement.

color_chart.png

View solution in original post

2 Replies
Sergey_Shuklin
Specialist
Specialist

Hello!

Use Above() function and some cosmetical hints. You can find some at the attachement.

color_chart.png

Pedro_Rodriguez
Contributor III
Contributor III
Author

Thanks man!

Works nicely