topic Re: Dynamic axis for sctterchart in QlikView

Dynamic axis for sctterchart

Wed, 25 Nov 2020 16:16:04 GMT

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

i want to get the list box like

listbox1:--

listbox1(xaxis)

listbox2:

listbox1(yaxis)

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

Re: Dynamic axis for sctterchart

Anonymous — Thu, 17 Nov 2016 13:12:20 GMT

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

Re: Dynamic axis for sctterchart

Thu, 17 Nov 2016 13:24:03 GMT

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

Re: Dynamic axis for sctterchart

Anonymous — Thu, 17 Nov 2016 13:32:13 GMT

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?

Re: Dynamic axis for sctterchart

Anonymous — Thu, 17 Nov 2016 13:42:02 GMT

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

Re: Dynamic axis for sctterchart

Thu, 17 Nov 2016 13:43:09 GMT

yeah ,

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

o i cant create those many listboxes

Re: Dynamic axis for sctterchart

kaushiknsolanki — Thu, 17 Nov 2016 13:47:24 GMT

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

Re: Dynamic axis for sctterchart

Anonymous — Thu, 17 Nov 2016 13:59:51 GMT

Sample attached

Hopefully this helps!

Re: Dynamic axis for sctterchart

Anil_Babu_Samineni — Thu, 17 Nov 2016 14:27:41 GMT

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

Re: Dynamic axis for sctterchart

MarcoWedel — Thu, 17 Nov 2016 23:40:52 GMT

Hi,

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

Re: Dynamic axis for sctterchart

Fri, 18 Nov 2016 10:21:16 GMT

Hi kaushik,

yes , i need the same output as in the image

can you please elaborate it how can i enable or disable expression using variables

Re: Dynamic axis for sctterchart

Fri, 18 Nov 2016 10:23:28 GMT

Hi Anil,

thanks for the reply

the fields that i am having in the listboxes are not dimensions they are measures

Re: Dynamic axis for sctterchart

Fri, 18 Nov 2016 11:11:38 GMT

Hi,

I tried this method before

it is showing no data available though is there data is for the particular selections

Re: Dynamic axis for sctterchart

Mon, 28 Nov 2016 10:19:45 GMT

Hi ,

Can you please elaborate it

Re: Dynamic axis for sctterchart

MarcoWedel — Fri, 02 Dec 2016 00:14:09 GMT

can you post a sample of your application to demonstrate the issue?