topic Re: scatter chart in QlikView

scatter chart

deepakqlikview_123 — Sat, 11 Apr 2015 14:17:13 GMT

Hi All,

Please find my attached scatter chart.

there is a usage of calculated dimension.[Right(INDICATOR NAME,4)]

My requirement is only show four characters for CHSP and CLDT.Moreover after using this condition i got blank spaces and some unwanted letters.

For remaining indicators i need to show only last 3 characters.

Can you please suggest how shall i go ahead.

Thanks

Re: scatter chart

MK_QSL — Sat, 11 Apr 2015 14:37:00 GMT

Use below

MID(INDICATOR_NAME, INDEX(INDICATOR_NAME,' ',SubStringCount(INDICATOR_NAME,' '))+1)

Re: scatter chart

sunny_talwar — Sat, 11 Apr 2015 14:38:50 GMT

In the attached file I just see AHP and AHT on the chart. Not sure where do you see extra spaces or letters? Please attach a sample which shows your problem.

Best,

Sunny

Re: scatter chart

deepakqlikview_123 — Mon, 20 Apr 2015 07:45:15 GMT

Hi Manish,

If name is AHT or AHP I need to show blue color otherwise need to show black color on chart please suggest.

Thanks