topic Re: Scatters Chart in QlikView

Scatters Chart

amilafdo — Wed, 30 Jul 2014 04:59:09 GMT

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'

but I want to display as below;

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

Thanks

Amila

Re: Scatters Chart

Wed, 30 Jul 2014 05:00:50 GMT

Hi Amila,

Please share you qvw, I can check.

Thanks

Arindam Roy

Re: Scatters Chart

SunilChauhan — Wed, 30 Jul 2014 05:34:06 GMT

create one more expression and type salespersonname field

change chart type -. combochart

uncheck symbols

and change the chart to scatter

Re: Scatters Chart

amilafdo — Wed, 30 Jul 2014 05:53:27 GMT

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

Re: Scatters Chart

SunilChauhan — Wed, 30 Jul 2014 05:58:59 GMT

for first expression uncheck Text on popup

in second expression i mentioned

you could use below

=sales personname &'

'&first expression

hope this helps

Re: Scatters Chart

amilafdo — Wed, 30 Jul 2014 06:01:17 GMT

Hi,

i got the idea.

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

Thanks

Amila

Re: Scatters Chart

amilafdo — Wed, 30 Jul 2014 06:28:16 GMT

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

Re: Scatters Chart

SunilChauhan — Wed, 30 Jul 2014 06:54:20 GMT

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

Re: Scatters Chart

amilafdo — Wed, 30 Jul 2014 07:22:32 GMT

Re: Scatters Chart

amilafdo — Wed, 30 Jul 2014 07:24:53 GMT

Hi,

please find the above print screen...

thanks

Amila