Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
trishita
Creator III
Creator III

How to add records of same quantity

I need to add computed rob and actual rob for same type of nifuel type

5 Replies
sasikanth
Master
Master

Could you please corroborate a bit more like How to calculate rob values etc..

trishita
Creator III
Creator III
Author

its coming directly from the database

Anil_Babu_Samineni

Can you provide sample input and expected result in Inline at least instead image?

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful
thevingo
Creator
Creator

Hi

try :

Load distinct Nifueltype,

          Sum(computedROB) as computedROB,

          Sum(ActualROB) as ActualROB,

resident YourTable group by Nifueltype;

Hope this helps

trishita
Creator III
Creator III
Author

I dont want to do it in script level but in the chart expressions