topic Re: Multiple fields on Y-axis in QlikView

Multiple fields on Y-axis

Fri, 12 Dec 2014 14:02:01 GMT

I have following representation.

I'm displaying values of a field (say population) at Y=1. Now I would like to add another field (say age) at Y=2. How can I define Y axis and corresponding field values on Z_axis in a bubble chart?

Re: Multiple fields on Y-axis

francoiscave — Fri, 12 Dec 2014 14:17:31 GMT

Hi Nishant,

Do you use the scatter Chart ?

If yes, you can use the X,Y and Z axis.

Can you post an app and the expected result ?

François

Re: Multiple fields on Y-axis

Fri, 12 Dec 2014 14:56:57 GMT

Yes, I'm using scatter chart. It's not really possible to post that app here. I just want some of my fields to be represented simultaneously on Y-axis. In the above example I have a field represented at Y=1. So all the values of that field appear in the front of Y=1. Similarly for any other field, it should appear at say Y=2. Please let me know if you are still not clear with the use case.

Re: Multiple fields on Y-axis

Fri, 12 Dec 2014 17:11:31 GMT

Here I've attached a sample which looks similar to my data model. I have represented 'LifeExpectancy' on Y=1. Dimension used is 'Year'. X Axis represents average 'Population'. I would like to have bubbles for 'NumberOfParks' and 'NumberOfSchools' represented on Y=2 and Y=3 respectively.