Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
amilafdo
Creator
Creator

Scatters Chart


Hi,

I want to dispaly the sales person on data labels & want to remove the Axies names & District. currently shows the Both Axies,District & Sales value in Scatters Chart (Map).

if it is possible in Qlikview how can shows the Saleperson Sales value.

Eg:

Currently Shows as below format;

District      =     ' District Name '

SalesPerson = ' Sales Person Name'

District      =     ' District Name '

SalesPerson = ' Sales Person Name'

District      =     ' District Name '

SalesPerson = ' Sales Person Name'

AX:

AY:

'Sales Value' Only values show

'Sales Value'

'Sales Value'

but I want to display as below;

'Sales Person Name' = ' for the particular Sales person Sales Value'

'Sales Person Name' = ' for the particular Sales person Sales Value'

'Sales Person Name' = ' for the particular Sales person Sales Value'

Thanks

Amila

1 Solution

Accepted Solutions
SunilChauhan
Champion II
Champion II

create one more expression  and type salespersonname field

change chart type -. combochart

uncheck symbols

and change the chart to scatter

Sunil Chauhan

View solution in original post

9 Replies
Not applicable

Hi Amila,

Please share you qvw, I can check.

Thanks

Arindam Roy

SunilChauhan
Champion II
Champion II

create one more expression  and type salespersonname field

change chart type -. combochart

uncheck symbols

and change the chart to scatter

Sunil Chauhan
amilafdo
Creator
Creator
Author

Hi chauhans85,

Thanks for the reply...

'create one more expression  and type salespersonname field' - This is work fine for Scatters Chart(Map).

And display ;

Sales Value

Sales person Name

Sales Value

Sales Person Name

Can i changed it to as;

Sales person Name

Sales Value

Sales person Name

Sales Value

Thanks

Amila

SunilChauhan
Champion II
Champion II

for first expression uncheck  Text on popup

in second expression i mentioned

you could use below

=sales personname &'

'&first expression



hope this helps

Sunil Chauhan
amilafdo
Creator
Creator
Author

Hi,

i got the idea.

i have create another expression for Sales value & remove 'Text as pop-up' from ealier Sales value.

Thanks

Amila

amilafdo
Creator
Creator
Author

Hi,

After i add the new expression my older legend changed to the new expression. if i remove 'Expression as Legend', not showing any legend.

thanks

Amila

SunilChauhan
Champion II
Champion II

can you please explain bit more or attched screen shot of befor and after

Sunil Chauhan
amilafdo
Creator
Creator
Author

Before.jpgAfter.jpg

amilafdo
Creator
Creator
Author


Hi,

please find the above print screen...

thanks

Amila