topic Re: Selected field unexpected multiple value in chart in QlikView

Selected field unexpected multiple value in chart

Jogi — Sat, 16 Nov 2024 02:26:27 GMT

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))

Re: Selected field unexpected multiple value in chart

sunny_talwar — Thu, 19 Sep 2019 11:33:02 GMT

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

Re: Selected field unexpected multiple value in chart

Jogi — Thu, 19 Sep 2019 12:52:27 GMT

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

value goes high:

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

Re: Selected field unexpected multiple value in chart

sunny_talwar — Thu, 19 Sep 2019 13:05:58 GMT

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

Re: Selected field unexpected multiple value in chart

Jogi — Thu, 19 Sep 2019 14:35:08 GMT

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

Re: Selected field unexpected multiple value in chart

Jogi — Thu, 26 Sep 2019 12:35:41 GMT

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