Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have, for example, the following data:
Asset Performance
Asset 1 5%
Asset 2 3%
Asset 3 8%
Asset 4 10%
I would like to create a table showing every Asset and the result of Asset x Performance - Asset 1 Performance. The result should be the following:
Asset 1 0%
Asset 2 -2%
Asset 3 3%
Asset 4 5%
I wrote Sum([Performance])-sum({<Asset={'Asset 1'}>}[Performance]) and, as a result, only Asset 1 is being subtracted.
Many thanks in advance
@jaimeoconor Are you using Qlik View or Sense? I would like to move this into the correct product forum. This forum is typically for platform-related discussions.