Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

sum based on another fields

Hi QV,

I have a table like attached one.....I want to sum the each field based on FACILITY_ID and Metrics.

Like

Sum(PRIOR_FW_VAL) based on FACILITY_ID and Metrics,

Sum(PRIOR_MONTH_VAL) based on FACILITY_ID and Metrics,

Sum(PRIOR_QTR_VAL) based on FACILITY_ID and Metrics,

I have tried with aggr but unable to successed.

any help would appreciate.

Thank

4 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Try using a pivot table and enabling partial sums on the Presentation tab for the two dimensions. If that doesn't do what you want, please explain in more detail what you do want and post an example qvw document with data.


talk is cheap, supply exceeds demand
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

I don't understand what you want. If you want to sum values to get totals per facility-metrics combination then simply add those two dimensions to your straight table.


talk is cheap, supply exceeds demand
ashfaq_haseeb
Champion III
Champion III

Hi,

may be like this.

Regards

ASHFAQ

MarcoWedel

like this?:

QlikCommunity_Thread_129759_Pic1.JPG.jpg

hope this helps

regards

Marco