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.
