Discussion Board for collaboration related to QlikView App Development.
I have the following requirement:
1. Need to display only numbers in cells that is marked in 'Blue'. I am using RowNo(Total) in expression to achieve this. Is there a better approach? My tale will have 10 rows (Always static).
2. Need to display partial sums only for the cells marked in 'RED' i.e. right under the 'BLUE' cells. How can we do this? I see that RowNo(Total) will not be applicable for Partial sums.
Can you post the sample qvw?
Untested, but if your quarters on the top and left are two different date fields, as I would suggest they should be, it seems like you just need to put your current calculation in an if() like this:
if(TopField >= LeftField,CurrentCalculation)
And then do partial sums like normal.