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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
aaarox
Contributor
Contributor

Dropdown box linked to a mapping table

Hi,

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'

Labels (3)
1 Solution

Accepted Solutions
WaltShpuntoff
Employee
Employee

This sounds like something I did a long time ago - here is a writeup: https://radishbits.wordpress.com/2013/12/21/qlikpivot/

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. 

HTH

-ws

View solution in original post

3 Replies
WaltShpuntoff
Employee
Employee

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? 

-ws

aaarox
Contributor
Contributor
Author

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).

Thanks!

WaltShpuntoff
Employee
Employee

This sounds like something I did a long time ago - here is a writeup: https://radishbits.wordpress.com/2013/12/21/qlikpivot/

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. 

HTH

-ws