topic Conditionally display partial sums in QlikView

Conditionally display partial sums

rishimessi19 — Thu, 13 Oct 2016 16:15:27 GMT

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.

Regards

Rishi

Re: Conditionally display partial sums

settu_periasamy — Thu, 13 Oct 2016 19:20:35 GMT

Can you post the sample qvw?

Re: Conditionally display partial sums

johnw — Thu, 13 Oct 2016 19:29:04 GMT

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.