Chart including relative values evolution

Pedro_Rodriguez — Tue, 09 Oct 2018 11:02:34 GMT

Hi all,

I'm trying to get something like this:

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!

Re: Chart including relative values evolution

Sergey_Shuklin — Tue, 09 Oct 2018 12:04:08 GMT

Hello!

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

Re: Chart including relative values evolution

Pedro_Rodriguez — Tue, 09 Oct 2018 13:39:39 GMT

Thanks man!

Works nicely

topic Re: Chart including relative values evolution in QlikView

Chart including relative values evolution

Re: Chart including relative values evolution

Re: Chart including relative values evolution