Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Jack_Sayam
Employee
Employee

Table function not calculating results

Hello,

So I have this table where the growth rate is calculating correct if it actually calculates, but some of the results of the growth rate calculate to "-", essentially nothing. Is something wrong with my expression? (=(((Sum(InvAmt))-(Above(Sum(InvAmt))))/(Above(Sum(InvAmt))))*100)

I want to calculate it when the year switches.

Thanks for your time.

Example

cool.png

7 Replies
dplr-rn
Partner - Master III
Partner - Master III

Can you re-upload the image? it is not available (for outside qlik )
Jack_Sayam
Employee
Employee
Author

Thank you for replying. I had re-upload it. Please tell me if you can view it 

sunny_talwar

May be try this

If([Sales Rep] = Above(TOTAL [Sales Rep]),
(((Sum(InvAmt))-(Above(TOTAL Sum(InvAmt))))/(Above(TOTAL Sum(InvAmt))))*100))
Jack_Sayam
Employee
Employee
Author

It does not work initially (because of expression errors) but I will edit it more and see what I can do. Thank you for your input 🙂
dwforest
Specialist II
Specialist II

are all the fields just straight values or does Sales include a set expression to reset on year?

This would cause problems when you remove month from the table; essentially showing null for Year.

Jack_Sayam
Employee
Employee
Author

Well sales I think is just straight values has a very simple sum expression, Sum(InvAmt)
dwforest
Specialist II
Specialist II

Posting a sample of the qvd would be helpful to get further help