Dynamic axis in qlikview

[#1]

I have a table with column names

table

abc,

def,

gef

from sql  select * table

in my list box i need to get all the column names in the single box like

abc

def

gef

and  then i need to create a scatter chart with the dynamic axis

for example if i click on abc then in the axis it has to give the abc details in the chart

i tried with $field and got all the fields but the data is not reflecting.

pl find the attached .

[neelamsaroha157]

Try

Create an inline table

Load * Inline

[Dimension, Dimension_Name

abc,ABC

def, DEF

gef, GEF

I

];

Then dimesion expression

=[$(=subfield(Concat(DISTINCT [Dimension], '^'),'^',1))].

Make sure that the actual values in first column of inline matches with your actual tables.You can use second column to rename the fields if you want.

Hope this helps