Dynamic axis for sctterchart

[#1]

Hi,

I have a requirement like

all the column names i want to get it into two different listboxes

like if i have column like

q,

w,

e,

r

i want to get the list box like

listbox1:--

listbox1(xaxis)

q

w

e

r

listbox2:

listbox1(yaxis)

q

w

e

r

and i want to create a scatter chart where x-axis and y-axis should change dynamically on selecting the fields in the listbox

i created the listboxes by using $field and getfieldselection

but the values are not changing as per selection.please help me to resolve this issue or suggest me if there is any different process

Thanks in advance

[Anonymous]

Do you have a current and desired output that you can share with us?

[#3]

i am not able to give my current ouput but the desired output is

[Anonymous]

So in your drop down box you want to specify for the X Axis, Select Shipped QTY = 10 for example and it must filter the chart?

[Anonymous]

Oh, You want to dynamically change the dimensions in your scatter plot based on the listbox above.

If you go to : Help > Show Start page

On the left there is Examples, scroll down to Whats new in QlikView11

Go to the Reports tab

Here it allows you to make a selection and the report fields change dynamically.

A similar concept can be used.

They create a data island that is not connected to the rest of the data and inline load exact field names in there.

they then use conditional show hide on the Dimensions i.e

If the User selects the Option region:

=SubStringCount(Concat(_dimension, '|'), 'Region')

The above expression will allow the dimension to be activated.

In your case select one value always selected to avoid having multiple dimensions per axis being selected

[#6]

yeah ,

but there are almost 86 columns  i need to create as x-axis,y-axis

o i cant create those many listboxes

[kaushiknsolanki]

Hi,

Do you require the same output/functionality as you shown in image?

If yes then you will have to create those many expressions and not dimensions/listbox.

Then using the variable button you can enable and disable expression to change on chart.

Regards,

Kaushik Solanki

[Anonymous]

Sample attached

Hopefully this helps!

[Anil_Babu_Samineni]

Seems, This. Does this work for you. Don;t worry about visualization. We can work on it after screen selection

[MarcoWedel]

Hi,

maybe using the system field $Field in alternate states multiboxes together with some dollar sign expanded expressions could be a solution as well:

see also:

The Magic of Dollar Expansions

The Magic of Variables

hope this helps

regards

Marco