Discussion Board for collaboration related to QlikView App Development.
appreciate if a solution is proposed in order to either avoid being appeared term " NON PAYABLE' in the last row or to make it disappear in the row. But this needs to be shown as it is in all other rows!
This is what you propose! the text 'Non Payable" is an expression so is it possible to apply this. Could you please elaborate more on this. Also the expression you propose carries a comma & inward comma & so on which are vague since it is not on a straight line. Please rewrite this.
Thanks In advance!
If( Dimensionality() > 0,
Sum( Field ),
I like to break out my expression, it makes it a bit easier to read:
If( Dimensionality() > 0, // Condition to test
Sum( Field ), // Then
'' // Else
Written as a single line:
If ( Dimensionality() > 0, Your Expression goes here, '' )