topic Getting the total in QlikView

Getting the total

Mon, 08 Apr 2013 13:51:17 GMT

Hi All,

I need to get the total of the values in my table. please see the sample table:

The red fonts in march are the total from feb. I need to set the beginning balance of the next month of the totals.

feb beginning balance is already given.

Thanks,

Donna

Tue, 09 Apr 2013 01:00:26 GMT

bump

Wed, 10 Apr 2013 01:40:26 GMT

danieloberbilli — Wed, 10 Apr 2013 08:40:05 GMT

Dear Donna,

Could you add a qvw.-file, so that is easier to see the input and what you are looking for.

Kind regards

Daniel

lucas4bi — Wed, 10 Apr 2013 10:44:55 GMT

Given that you have 2 expressions: FILLED as first expression and BULK as second, try with something like this:

If( Category='Beginning Balance',

if(Columnno(Total)=1, CALCULATE GIVEN VALUE, //check the first column with the given value to return (feb)

before(total bottom(total column(1) ) ) //returns the bottom cell calculated in the previus dimension (total)*

)

change column number for each new expression you want to check, for BULK it would be "column(2)" and ColumnNo(Total)=2.

*total must be a category value, it doesn't check the cell created using the "partial sum" checkbox.

Luca