Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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