Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
usr1
Contributor II
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)
1 Solution

Accepted Solutions
vinieme12
Champion III
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.

View solution in original post

3 Replies
vinieme12
Champion III
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.
usr1
Contributor II
Contributor II
Author

Thank you that worked perfectly! 

vinieme12
Champion III
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.