I'm having some troubles with creating more dynamic variables linked together by a mapping table.
I have a csv with 5 columns (DATA, a_1, a_2, b_1, b_2) with numerical values and a mapping table with three columns (Var, Var_1, Var_2).
The table contains [Var, Var_1, Var_2
a, a_1, a_2;
b, b_1, b_2].
In order to use a dropdown box in the configuration mode: -I initialize an empty variable called 'SelectedVariable='';'
-I inizialize a list as 'List = 'a | b '
-> in this way, i can select in the dropdown box the variable 'a' or the variable 'b'.
Now, I would like to create two dynamic variables (DynVar1 and DynVar2) which pick the values of Var_1 and Var_2 corresponding to Var (=SelectedVariable) in the mapping table, so that i can use these dynamic variables into a line graph to represent the values contained in the csv.
Is there a way to do this in QlikSense?
Example: when i select 'a' in the dropdown list, DynVar1 should be 'a_1' and DynVar2 should be 'a_2'. By plotting in the graph DynVar1 and DynVar2 I should view the data contained in the csv in the columns 'a_1' and 'a_2'
This involves using an island table which defines all of the possible combinations, omitting the ones where a field appears twice. I don't know if I would still do it that way, this may get you further down the path.
You can do some really creative things using the variable input control if you use the dynamic value feature and drive that off of your table.
The term "mapping table" has a very specific meaning in Qlik. It is used for key-value translations, and is automatically dropped at the end of the load script. This is making your question confusing.
Can you explain what you are trying to accomplish at a higher level?
Yes sorry, for me "mapping" was only the name of the table.
My goal is to create two variables by selecting just one variable through a dropdown list. The two variables should be selected from the table imported in QlikSense.
For example, by selecting "a" in the dropdown list, i want that DynVar1 is equal to "a_1" and DynVar2 is equal to "a_2". In this way with JUST ONE SELECTION, i can represent more variables in a line chart (this is a simple example but my problem is way more complex).
This involves using an island table which defines all of the possible combinations, omitting the ones where a field appears twice. I don't know if I would still do it that way, this may get you further down the path.
You can do some really creative things using the variable input control if you use the dynamic value feature and drive that off of your table.
