Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Could you add a qvw.-file, so that is easier to see the input and what you are looking for.
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.