Hi almighty Qlik community,
I stumbled upon this and I am so stuck and I have a deadline tomorrow, appreciate someone experienced could help me with it.
I have this Orig. Data as below, it is kind of like two unlinked tables.
I have to create a table in Qliksense based on a selection > in this example, when I filter for Scenario 'Up', I would like to map the Industry value to Industry 2, and create a table as the bottom table below (New Table). What should I set as dimension and what as measure in the Table, and how can I write my expression? (for which dimension/measure)?)
Thanks in advance!!
Cheers,
F
| Orig. Data | | | |
| Industry | Scenario | ID | Industry 2 | Sales |
| A | Up | | | |
| B | Up | | | |
| C | Down | | | |
| D | Down | | | |
| E | Down | | | |
| | | 1 | A | 100 |
| | | 2 | A | 200 |
| | | 3 | B | 300 |
| | | 4 | B | 400 |
| | | 5 | C | 500 |
| | | | | |
| New Table | | | | |
| Industry 2 | Sales | ID | | |
| A | 100 | 1 | | |
| A | 200 | 2 | | |
| B | 300 | 3 | | |
| B | 400 | 4 | | |
