topic Re: Dynamic axis in qlikview in QlikView

Dynamic axis in qlikview

Wed, 25 Nov 2020 16:16:04 GMT

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 .

Re: Dynamic axis in qlikview

neelamsaroha157 — Thu, 03 Nov 2016 17:59:37 GMT

Try

Create an inline table

Load * Inline

[Dimension, Dimension_Name

abc,ABC

def, DEF

gef, GEF

];

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