Scatter chart

[deepakqlikview_123]

Hello All,

Pleas find attached QVW.

I have values for  EBITA and Multiple.

there are total 32 values.

In dimension field i need to set values.

For eg if value is AHT i have indicators as EBITDA Multiple AHP and Revpar AHP

I need to plot chatter chart can you please suggest how shall i ho ahead.

Thanks

[Anonymous · Accepted solution]

are you looking for something like this ?

[deepakqlikview_123]

thanks Bhagirath your solution works

[Anonymous]

Great...!!!

[deepakqlikview_123]

Hi All,

I wanr to show CHSP and CLDT only by selecting 4 characters from right side. for all others I need to show last three letters only.If I can use 4 letters from right side it is showing unwanted spaces.

Can you please suggest

[Anonymous]

Hi Deepak,

use like this

Trim(right(INDICATOR_NAME,4))