Pivot Table with load inline variables

vmoreno2605 — Sat, 16 Nov 2024 04:29:41 GMT

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!

Re: Pivot Table with load inline variables

treysmithdev — Wed, 02 Oct 2019 19:06:31 GMT

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.

topic Pivot Table with load inline variables in App Development

Pivot Table with load inline variables

Re: Pivot Table with load inline variables