topic Re: Re: Scatter chart dot colors dimension setup not working in QlikView

Scatter chart dot colors dimension setup not working

Thu, 05 Dec 2013 15:14:18 GMT

I have some data that I want to display in scatter chart.
I have 2 dimensions
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension1 - this is each record in the table - say unique id for each row. So the number of dots should be equal to number of records.
- dimension2 - this is a combination of 2 columns. tp and vc. Colors of each dot is based on these 2 columns

tp    vc
a      1
b      2
c      1

So there will be dots of 3 colors based on the above tp and vc combinations

Then there are 3 expressions representing X and Y and Size of dot

I am not sure how to configure the dimensions to achieve the goal.

Thanks

Re: Scatter chart dot colors dimension setup not working

Gysbert_Wassenaar — Thu, 05 Dec 2013 15:37:31 GMT

Can you post a example with sample data?

Re: Scatter chart dot colors dimension setup not working

Thu, 05 Dec 2013 15:50:38 GMT

ID tp vc yi ye q

1 m v1 10 1.2 10

2 cm v2 21 2.5 20

3 m v1 8 1.0 10

4 cm v2 12 3.5 40

5 mm v3 14 4.0 10

So ID represents each dot, tp and vc together represent color, if there are 5 unique combonations then dots will be of 5 colors. ye is X, yi is Y and q is Z

Hope that helps

Re: Re: Scatter chart dot colors dimension setup not working

Gysbert_Wassenaar — Thu, 05 Dec 2013 16:38:55 GMT

see attached qvw

Re: Scatter chart dot colors dimension setup not working

Thu, 05 Dec 2013 16:55:19 GMT

Thanks for your help Gysbert, I think this works for me, have to test with my data.