Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
vmoreno2605
Creator
Creator

Pivot Table with load inline variables

Hi everyone! I have the following issue:

 

I the following excel:

clipboard_image_0.png

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

clipboard_image_2.png

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

clipboard_image_4.png

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!

Labels (2)
1 Solution

Accepted Solutions
treysmithdev
Luminary Alumni
Luminary Alumni

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.

Blog: WhereClause   Twitter: @treysmithdev

View solution in original post

1 Reply
treysmithdev
Luminary Alumni
Luminary Alumni

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.

Blog: WhereClause   Twitter: @treysmithdev