topic Re: Summarizing numeric fields from a row, in one single field in QlikView

Summarizing numeric fields from a row, in one single field

npadilla73 — Fri, 03 Jul 2015 16:03:38 GMT

Hi,

I created a pivot table, with 5 dimention, but I need to sum several columns, depend of my search the number of columns.

In this moment, the requirement is summarize row by row, given the columns.

I have added a Calculated Dimention in my pivot table, but I do not know how to use the sentence For.

Somebody can Help me out.

Thanks

Re: Summarizing numeric fields from a row, in one single field

swuehl — Fri, 03 Jul 2015 17:09:22 GMT

Could you describe your setting a bit more detailed? Best by uploadin a small sample QVW to this thread.

If you want to sum some numeric values, you can look into rangesum() function, e.g. to sum columns 1 and two in a chart:

=rangesum( column(1), column(2) )

Re: Summarizing numeric fields from a row, in one single field

npadilla73 — Fri, 03 Jul 2015 18:23:04 GMT

Thanks for your answer,

That's exactly what I did, "= RangeSum(Column(1), Column(2))" in a Calculated Dimension field. But only show me a cero values. It's important to mention, some field in my expretion are null.

Re: Summarizing numeric fields from a row, in one single field

swuehl — Fri, 03 Jul 2015 18:36:56 GMT

I believe that should go into an expression, not calculated dimension.

To help you more, you need to explain what you are trying to achieve a bit more detailed. Best by creating and uploading a small sample QVW.

Re: Summarizing numeric fields from a row, in one single field

npadilla73 — Fri, 03 Jul 2015 19:08:56 GMT

I will work on it, give me some minutes. For the moment, I send you an image, how my pivot table visualizes my data.

Re: Summarizing numeric fields from a row, in one single field

swuehl — Fri, 03 Jul 2015 19:12:35 GMT

Are you looking for a partial sum for dimension Day?

You can enable this in presentation tab of pivot chart properties.

Re: Summarizing numeric fields from a row, in one single field

npadilla73 — Fri, 03 Jul 2015 19:29:04 GMT

In the column SumRow (It is a calculated dimension), I need to sum all the colums, per row, but It depends of the numbers of days.

It's ok, The partial sum per column, but I need it per row too, and that's where I am stuck,

Re: Summarizing numeric fields from a row, in one single field

MarcoWedel — Sat, 04 Jul 2015 07:35:49 GMT

in the presentation tab of the chart properties mark your "day" dimension and check the "show partial sums" check box.

hope this helps

regards

Marco

Re: Summarizing numeric fields from a row, in one single field

npadilla73 — Mon, 06 Jul 2015 17:15:25 GMT

Thanks Marco, that's what I need. I did not understand to swuehl at the begining, but I think he tried to explaining what you wrote.

Thanks again.