topic Re: Mismatch total ? in QlikView

Mismatch total ?

Tue, 24 May 2016 05:25:16 GMT

HI All,

I am getting the Total Mismatch, I have used sum(Distinct Value ) in the Expression..

Getting the Value in the Each & every month is correct, Only thing is getting mismatch in the Total.

Kindly help me on this..

Regards,

Helen

Re: Mismatch total ?

ajsjoshua — Tue, 24 May 2016 05:31:34 GMT

Hi Betty

what u r getting on sum(Value)

Re: Mismatch total ?

marcus_sommer — Tue, 24 May 2016 05:45:26 GMT

The reason for this behaviour will probably be the distinct key-word within your expression. If you really need it there you will need an aggr-function to eliminate the distinct-effect across the month. Try something like this:

sum(aggr(sum(distinct Value), Month))

- Marcus

Re: Mismatch total ?

ajsjoshua — Tue, 24 May 2016 05:47:35 GMT

Hi,

You can use advanced aggregation to get the sum of rows:

=Sum( Aggr( YourExpression, Type))

Re: Mismatch total ?

Tue, 24 May 2016 05:49:54 GMT

sum(aggr(sum(value),month))

Re: Mismatch total ?

Tue, 24 May 2016 05:52:46 GMT

Thanks Marcus.

Regards,

Helen