topic How to keep the same legend in Scatter Chart? in QlikView

How to keep the same legend in Scatter Chart?

Anonymous — Mon, 01 Aug 2011 07:52:39 GMT

In Data Visualization, which one of the QV Demos, there is a Scatter Chart "Two dimensions and three expressions" in sheet "Relationship".

When I select a rep, the legend in this chart will be change to "Year", and the color of these 2 dots of this 1 rep will be different.

How can I keep the legend "Sales Rep" when I select only 1 rep?

lironbaram — Mon, 01 Aug 2011 08:05:03 GMT

hei

not extly what you asked for but maybe an idea

when one sales person is selcted

add his name to the chart title

then you will get also the legend pointing more clearly on the years

and also the sales rep

just change the title to

='Sales and Margin Movements from ' & (

Max(Year)-1) & ' to ' & Max(Year) & ' ' &if(isnull(only([Sales Rep Name]))=0,[Sales Rep Name])

Anonymous — Tue, 02 Aug 2011 02:19:02 GMT

Thank you liron baram, but I prefer achieve in chart to in title.