Pivot Table with load inline variables

[vmoreno2605]

Hi everyone! I have the following issue:

I the following excel:

I use the field 'Formula' in order to use it in this way on a qlik sense pivot table:

I have used this in the same one using only one dimension and it works, the problem here is that when i try it using more than one dimension ir does not work as expected until i apply some selections

When i apply selections (ignore the one that i tried to cover, that's from a different and independent table) it works!

Any idea why?

Thanks in advance!

[treysmithdev · Accepted solution]

The dollar sign expansion is happening before it gets executed. So what this means is, it doesn't have any dimensionality. So when you select one, it is filtered to one value. When you don't have one selected, there isn't a single value and it can't decide, resulting in NULL.

The only way I know of handling this is using a PickMatch expression.