Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
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