topic Re: Sum by fields in QlikView

Sum by fields

Wed, 25 Nov 2020 16:16:04 GMT

Hi community,

I figure I try to explain the issue I have with a picture to see if anyone could find a solution.

In the pic you see 2 tables from different sources, ideal they would both show same amount of rows and same total turnover.

Is it possible to sum by values so sume turonver for Price, Side and SD?

So in the right table e.g. would be grouped into 1 row.

Also attached an example app

Re: Sum by fields

Gysbert_Wassenaar — Mon, 05 Dec 2016 08:46:04 GMT

Yes, remove all the columns that make the row unique. In other words keep only the columns that have the same value on every row: eod_MIC, eod_SD, eod_Side, eod_S... and eod_TD.

Re: Sum by fields

MK_QSL — Mon, 05 Dec 2016 08:46:57 GMT

Your question is not clear.. provide sample data or sample app to understand better.

Re: Sum by fields

Mon, 05 Dec 2016 09:09:02 GMT

Yeah I understand that option is available but Price is quantitity is still highly important but the sum sohuld not be based upon it. If you understand wha tI mean :S

Re: Sum by fields

Gysbert_Wassenaar — Mon, 05 Dec 2016 09:12:47 GMT

Sorry, I have no idea what you're talking about.

So in the right table e.g. would be grouped into 1 row.

That's possible if do as I explained above. Use only the dimensions that have the same value for every row. Use aggregation functions like sum to calculate whatever you think you need using the measure fields.