Qlik Community

App Development

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

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Ken_Hardwick
Contributor III
Contributor III

How to ignore filter selections in this formula?

Hello,

How do I ignore filter selections in this formula?

sum(Aggr($(vWrite_off_total),StockCode))

Thanks

 

1 Solution

Accepted Solutions
rubenmarin

Hi, you can use: sum({1}Aggr($(vWrite_off_total),StockCode)).

Additional {1} should be set on each function of the expression contained in vWrite_off_total

View solution in original post

2 Replies
rubenmarin

Hi, you can use: sum({1}Aggr($(vWrite_off_total),StockCode)).

Additional {1} should be set on each function of the expression contained in vWrite_off_total

Ken_Hardwick
Contributor III
Contributor III
Author

Thanks @rubenmarin

I did use the {1} in the main formula before posting this question but it is the additional requirements in the variable that is obviously causing the issue then. I did not think of that.

The variable vWrite_off_total contains more variables so a difficult change to make and I have not attempted the solution yet. But at least I know where the issue is.

Thanks for the solution.