Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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