# App Development

Announcements
Action-Packed Learning Awaits! QlikWorld 2023. April 17 - 20 in Las Vegas: REGISTER NOW
cancel
Showing results for
Did you mean:
Contributor II

## custom dimension not filtering

I have a custom dimension for a chart where I want to display the dollar amount for a certain cost codes within a subset of types. This dimension works EXCEPT when I try to filter on either the code or type from a filter.

Example:

`sum({<TY_LY={'TY'},[Code]={'A','B','C','D'},[Type]={'1','2','3','4'}>}[Dollar Amount])`

Lets say that the above formula totals \$100; and each Code equals \$25, if the user selects 'A' from the code filter I would expect that the total would then equal \$25 BUT it does not change.

Any help would be much appreciated. Thanks!

Labels (2)

• ### General Question

1 Solution

Accepted Solutions
Champion III

Try as below

sum({<TY_LY={'TY'},[Code]*={'A','B','C','D'},[Type]*={'1','2','3','4'}>}[Dollar Amount])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
3 Replies
Champion III

Try as below

sum({<TY_LY={'TY'},[Code]*={'A','B','C','D'},[Type]*={'1','2','3','4'}>}[Dollar Amount])

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Contributor II
Author

Thank you that worked perfectly!

Champion III

Great 🙂 , kindly close the thread by accepting the response as "Solution"

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
Tags
Community Browser