Dear all,
I have the following problem, shown below in the table: I am currently using a Pivot Table in Qlik Sense and I would like to be able to alternate between two measures, being Base Currency and Local Currency. Basically I would like to use these two columns as a dimension (which I am currently already using for dates and portfolio numbers).
Using ''alternate measures'' unfortunately doesn't work for pivot tables and I read some stuff about QsVariable // using inlines, but I'm not exactly sure if that applies to this example, since I want to vary between two different columns of values. Looking forward to your contributions.
Regards,
Rob
| Company | Transaction Type | Base Currency | Local Currency | Country |
|---|
| Company A | Dividend Received | 1,000 | 2,500 | ARGENTINA |
| Company B | Dividend Received | 2,000 | 2,250 | USA |
| Company C | Dividend Received | 3,000 | 9,000 | AUSTRALIA |
| Company D | Dividend Received | 4,000 | 26,000 | KUWAIT |
| Company E | Dividend Received | 5,000 | 5,000 | NETHERLANDS |
| Company F | Dividend Received | 6,000 | 6,000 | GERMANY |
| Company G | Dividend Received | 7,000 | 111,000 | SOUTHKOREA |
