topic Re: Issue with chart in QlikView

Issue with chart

ramanarayan — Wed, 25 Nov 2020 16:16:04 GMT

Hi QV Experts,

I am trying to create a straight table with 2 calculated expressions. The calculated expressions are actual missing qty and actual missing value for each of the customer at a part number level.

If you see, at a part number level the calculation works just fine. However, if you look at the sub-totals, they dont seem to work correctly.

Can someone help?

Attached is my qv sample.

Thanks,

Ram

Re: Issue with chart

Anil_Babu_Samineni — Thu, 18 Jan 2018 14:29:07 GMT

Looks like first one working as expected? For second one either you can use

OR, direct expression without any setting changes?

=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))

Re: Issue with chart

sunny_talwar — Thu, 18 Jan 2018 14:31:42 GMT

Try adding Sum(Aggr()) or use Sum of rows for Total mode

Re: Issue with chart

ramanarayan — Thu, 18 Jan 2018 14:41:52 GMT

Hi Sunny,

Appreciate it. It was a quick fix.

Howerver, i have this in a PIE chart and this option is not enabled. Any work around?

Thanks,

Ram

Re: Issue with chart

sunny_talwar — Thu, 18 Jan 2018 14:46:49 GMT

Use Sum(Aggr())

=Sum(Aggr((sum([Missing Quantity])-sum([Ordered Quantity]))*([ESC LAV]), Customer, [Part Number]))

Re: Issue with chart

ramanarayan — Thu, 18 Jan 2018 15:23:58 GMT

Thank You Sunny. Appreciate your help

Re: Issue with chart

sunny_talwar — Thu, 18 Jan 2018 15:25:37 GMT

no problem