topic Re: Line Graphs where two values are the same in QlikView

Line Graphs where two values are the same

Anonymous — Mon, 17 Aug 2015 08:18:45 GMT

Hi, hopefully a very simple question based on the attached example.

I have a line graph where the values for two of the lines are the same (ACTUALS & FCST2), on the graph one of the colours takes precedence (FCST2), however I want ACTUALS to show first.

Thanks

Nandy

Re: Line Graphs where two values are the same

alexandros17 — Mon, 17 Aug 2015 08:30:11 GMT

In the sort tab click Version dimension then write:

If(VERSION='ACTUALS', 2,1)

let me know

Re: Line Graphs where two values are the same

jonathandienst — Mon, 17 Aug 2015 08:31:24 GMT

Adjust the sort order on the chart for VERSION so that ACTUAL comes after FCST2 (Text, Z->A). The last drawn ine will overwrite the earlier lines.

You can reverse the legend order if you want that in ascending. Check Reverse Order in Properties | Presentation | (Legend) Settings

Re: Line Graphs where two values are the same

Anonymous — Mon, 17 Aug 2015 08:39:46 GMT

Thanks, both of those suggestions do the trick!