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