topic Scatter chart in QlikView

Scatter chart

Anonymous — Thu, 26 Jun 2014 15:04:55 GMT

Hi guys,

I have 4 sites, where were asked for each site Rating and Usage.

In database looks like Site1 Usage, site2 Usage, and so on

and the the same Site1 Rating, Site2 Rating and ...

I want to make a scatter chart depended on MYear and other variables.

I did it like a snap shot. Could you help me with ideas?

I think I need to crosstab load, but how?

Please see my sample file.

Thanks,

Re: Scatter chart

vgutkovsky — Thu, 26 Jun 2014 15:46:29 GMT

Vladimir, take a look at the attached. I created a new table called SiteData for you, which I think is what you're looking for. You can delete all instances of the word "ADD" which I just needed to perform a partial reload (since I didn't have your original data source). That's the general idea, although you can probably do it in less steps since you would be starting with the original data source instead of a partial reload.

Regards,

Vlad

Re: Scatter chart

Anonymous — Thu, 26 Jun 2014 16:51:50 GMT

Thanks Vlad.

Re: Scatter chart

nilo_pontes — Thu, 26 Jun 2014 17:00:03 GMT

Hi Vladimir,

Please take a look on the attached file.

I made some changes on your datamodel using crosstables.

Hope it helps you.

Regards