Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Dynamic axis in qlikview

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 .

1 Reply
neelamsaroha157
Specialist II
Specialist II

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