Skip to main content
Announcements
Introducing a new Enhanced File Management feature in Qlik Cloud! GET THE DETAILS!
cancel
Showing results for 
Search instead for 
Did you mean: 
padmanabhv
Contributor III
Contributor III

Use value form another column in chart based on selection in different column

Apologies if the subject makes no sense, I tried describing it the best way I could.
I have an inline load, which consists of field names which are being loaded from a different source.

LOAD * INLINE [
name,var_name,
field1,var1,
field2,var2,
field3,var3];

I also have a filter to select one from the "name" fields, for eg. the user selects field1, 
AND
Lets say I have a scatter plot where the Y axis 
=Only(Num#([$(=GetFieldSelections(name))]))

, which means in our example "field1" gets sent in as Y axis measure- this part works fine

I want the X axis to automatically select "var1"  and use the text "var1" as the measure. This is where I am having trouble !

Having a text box with =(var_name) outputs what I need, but when i try passing the same thing as a measure in the scatter plot, it says it is not valid.

Appreciate any help !

Labels (4)
1 Reply
padmanabhv
Contributor III
Contributor III
Author

Essentially what I want is a way to auto select the corresponding value in "var_name" based on the selection  in column "name".
not just display, but actually select it - that would work for me as well