topic Re: Weird things when using Aggr in Chart expression in QlikView

Weird things when using Aggr in Chart expression

Thu, 06 Nov 2014 11:43:24 GMT

Hi,

The best way to show what's happening here is in the attached .qvw.

I load the following data (in two inline-s):

And plot a chart, where Date is the dimension and the expression is:

=sum(aggr(

sum(if(decision='good',count)) * sqrt(sum(severity))

,custId))

The expression is so it must use the aggr expression in order to calculate correctly.

Now, as can be seen in the qvw, the chart is really wired (some dates are missing...):

what causes this behavior?

How can I deal with it?

Thanks!

MK_QSL — Thu, 06 Nov 2014 11:55:01 GMT

Go to presentation tab and untick Suppress Zero Values

rubenmarin — Thu, 06 Nov 2014 11:57:54 GMT

Hi Amalin, if you do aggr only by custID, it keeps only these two dates because in next dates doesn't appears any new cust, you can try with:

=sum(aggr(

sum(if(decision='good',count)) * sqrt(sum(severity))

,Date,custId))

Check attachment and look if that's what you want.