topic Re: Sum total with above not correct in QlikView

Sum total with above not correct

simoevry — Sat, 16 Nov 2024 04:18:39 GMT

Hi Everyone,

I need help for total result is not correct if someone can help Im begginer thanks

this my expression :

If(RowNo()=0 ,sum( aggr(FABS((Max(W_B1)))-above(Max(W_B1)),Date)),max(W_B1)-Above(max(W_B1)))/100

It should be get 24517,83 NOT 21873,82

sunny_talwar — Thu, 28 Feb 2019 12:54:01 GMT

May be try this

Sum(Aggr(
If(RowNo() = 0, Sum(Aggr(fabs((Max(W_B1))) -Above(Max(W_B1)), Date)), Max(W_B1) - Above(Max(W_B1)))/100
, Date))

simoevry — Thu, 28 Feb 2019 13:53:11 GMT

not work for me I get negative value.

thanks a lot for your reply

sunny_talwar — Thu, 28 Feb 2019 14:53:21 GMT

Would you be able to share a sample to test this out?

simoevry — Thu, 28 Feb 2019 15:41:21 GMT

sunny_talwar — Thu, 28 Feb 2019 17:18:41 GMT

Can you try this

Sum(Aggr(
If(RowNo() = 0, Sum(Aggr(fabs((Max(W_B1))) -Above(Max(W_B1)), (Date, (NUMERIC)))), Max(W_B1) - Above(Max(W_B1)))/100
, (Date, (NUMERIC))))

simoevry — Fri, 01 Mar 2019 11:03:56 GMT

thanks a lot it's work for me