Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
rishimessi19
Contributor II
Contributor II

Conditionally display partial sums

Hi

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

2 Replies
settu_periasamy

Can you post the sample qvw?

johnw
MVP
MVP

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.