I'm trying to design a scatter chart that allows the user to pick the x and y axis from lists of available variables. I have separate/duplicate lists of available variables for each axis for users to pick from. I want to plot the chosen variables for all test combos without [null] values. How do I do this in Qlik?
I've figured out how to plot two user selected variables against each other in a Combo Chart using the only(channel) aggregation. Currently with 4 variables I manage this with a series of if statements. I've also created two variables in the Settings/Variable Overview area, XPLOT & YPLOT, that are set to the Field Selections for my channel list boxes.
Once my dashboard goes from development to production the list of channels will be much larger and dynamic (channels may be created at any time). How can I use XPLOT & YPLOT to replace the series of logical statements?
This is what I have currently but it's not manageable moving forward.