Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Getting the total

Hi All,

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

Month YearFeb 2013Feb 2013Feb 2013Mar 2013Mar 2013Mar 2013
NO400040004000400040004000
Final CategoryCODEFILLEDBULKTotalFILLEDBULKTotal
Beginning Balance
1000100001100075527.00271,601.00347,128.00
Transfer 500.00200.00700.0051201343454,635.00
Gain 600.0024,453.0025,053.0023232564654587,886.00
Loss 2004.005,949.007,953.0032321312335,444.00
Purchase 62423.00239,999.00302,422.002312343242345,554.00
Total 75527.00271,601.00347,128.00184593.001186054.001370647.00

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

4 Replies
Not applicable

Re: Getting the total

bump

Not applicable

Re: Getting the total

up

danieloberbilli
Valued Contributor II

Re: Getting the total

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
Contributor

Re: Getting the total

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

Community Browser