Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

Sum total with above not correct

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

 

 

Qeror.JPG

 

 

Labels (3)
1 Solution

Accepted Solutions
Highlighted

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))))

View solution in original post

6 Replies
Highlighted

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))
Highlighted
Contributor
Contributor

not work for me I get negative value.

thanks a lot for your reply

Qeror.JPG

 

Highlighted

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

Contributor
Contributor

OK Smiley Happy

 

Highlighted

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))))

View solution in original post

Highlighted
Contributor
Contributor

thanks a lot it's work for me