topic Re: sum based on another fields in QlikView

sum based on another fields

Mon, 18 Aug 2014 09:15:06 GMT

Hi QV,

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

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

Re: sum based on another fields

Gysbert_Wassenaar — Mon, 18 Aug 2014 09:26:04 GMT

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.

Re: sum based on another fields

Gysbert_Wassenaar — Mon, 18 Aug 2014 09:44:23 GMT

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.

Re: sum based on another fields

ashfaq_haseeb — Mon, 18 Aug 2014 09:52:39 GMT

Hi,

may be like this.

Regards

ASHFAQ

Re: sum based on another fields

MarcoWedel — Mon, 18 Aug 2014 12:26:03 GMT

like this?:

hope this helps

regards

Marco