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: 
Jogi
Contributor III
Contributor III

Selected field unexpected multiple value in chart

Hello guys, i experienced problem when i selected value in filter, data in chart going high, instead of going down, do you know what may cause a problem? 

nummax(0,sum({<Type={'Current'}, [Age on Claim] = {1}>}[Total Claim Payment])
/
count({<Type={'Current'},[In service]={1}, ScopeText=, Description=, [Age on Claim] =, %FunctionKey=, [Module Team-Description]= ,
[Area]=, [Module Team]=, [Model Family]=>} DIM))

 

 

 

 

 

Labels (2)
1 Solution

Accepted Solutions
Jogi
Contributor III
Contributor III
Author

Just remove column name from function just like filter=, resolve the problem 

View solution in original post

5 Replies
sunny_talwar

Which filter are you selecting the value in? Are you able to share a sample where we can see the issue?

Jogi
Contributor III
Contributor III
Author

Yeah, sure when i select  value in filter, list box   

clipboard_image_0.png

value goes high: 

 

 

clipboard_image_4.png

Maybe you have any idea what to check, or where to start, because i checked tables, connection and everything looks good calculation works, besides that filter when i selected value unexpected value appear looks like it get multiple by some value 

sunny_talwar

This doesn't really help... are you able to share a qvw sample to look at?

Jogi
Contributor III
Contributor III
Author

Yes, can i send you via link using onedrive, because file is huge > 120 MB
Jogi
Contributor III
Contributor III
Author

Just remove column name from function just like filter=, resolve the problem