topic Re: Issue with total % in QlikView

Issue with total %

Wed, 25 Nov 2020 16:16:04 GMT

I'm having issue with one of my chart when I'm showing it in %.

If you see the legend is showing 6 values but the chart shows only two. And even the percentage in the chart is not matching even for those two as well.

We are having the issue because records are in multiple buckets.

I mean the individual record has a value in ACH as well as in other FMX as well on a particular day,

Exp:

sum({<Year=,TRANSACTION_DATE={'>=$(=Monthstart(AddMonths(max(TRANSACTION_DATE),-15)))'}>} NTPV_AMT) /

sum({<Year=,TRANSACTION_DATE={'>=$(=Monthstart(AddMonths(max(TRANSACTION_DATE),-15)))'}>} TOTAL <Month> NTPV_AMT)

Regards,

Sachin

Re: Issue with total %

sunny_talwar — Wed, 30 Mar 2016 14:22:16 GMT

If I remove Week and Week of Year from dimension, I am seeing this:

Your screenshot from the previous post did not seem to include those two as dimension

Re: Issue with total %

Wed, 30 Mar 2016 14:33:41 GMT

Hi Sunny,

But it doesn't seem to work for other date dimensions?

Re: Issue with total %

swuehl — Wed, 30 Mar 2016 14:34:02 GMT

I believe the issue is in your data model, see for example

TRANSACTION_DATE	FMX	Sum(NTPV_AMT)
1/3/2016	ACH	114,02
	BAL	1003,02
	CREDCARD	1003,02
	DEBCARD	1003,02
Total		1003,02

The expression total for that date does not sum up the rows. I would suggest you recheck the logic between your Transactions and Summary table.

Or maybe consider using a sum-of-rows using advanced aggregation.

Hope this helps,

Stefan

P.S. and please close the other thread...

Re: Issue with total %

swuehl — Wed, 30 Mar 2016 14:42:14 GMT

If you want to continue in a private discussion with Sunny, that's ok, but I would suggest that you close your public threads then.