I have created a Pivot Table in Qlikview. In it's simplest form, I have one dimension 'Invoice', and three expressions 'Net' (Sum(Net)) and 'VAT' (Sum(VAT)), and 'Net where VAT is nil'.
'Net where VAT is nil' is given by the following expression: Sum({$<VAT={0}>}Net). [Sum is used as each invioce may have multiple lines, so repeated instances in the data.
The result is that for a given invoice, the table lists the Net amount, the VAT and the 'Net where VAT is nil'.
'Net where VAT is nil' is zero when the VAT is not nil. What I want to do is only show those lines in the Pivot table where 'Net where VAT is nil' is not zero (i.e. those lines where the VAT is nil).
Can anyone help?
Edit:
Sample data attached. I want to only show the last line of this pivot table. And while the load script is quite simple in this example, I would prefer not to have a solution involving altering the load script too much.
Thanks.
