topic Re: Filtering a Pivot Table in QlikView

Filtering a Pivot Table

Mon, 08 Jun 2015 13:43:13 GMT

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.

Re: Filtering a Pivot Table

Anonymous — Mon, 08 Jun 2015 13:47:43 GMT

pls share the sample data

Re: Filtering a Pivot Table

siddheshmane — Tue, 09 Jun 2015 05:23:37 GMT

Hi,

Is this what you wanted ?

Re: Filtering a Pivot Table

qlikmsg4u — Tue, 09 Jun 2015 05:49:22 GMT

Hi see the attached app may help you.

Re: Filtering a Pivot Table

Fri, 12 Jun 2015 13:29:55 GMT

Thanks for your help, but I'm not exactly sure how you have managed to get the filter to work. I can't figure it out from your example.

Re: Filtering a Pivot Table

Fri, 12 Jun 2015 13:30:24 GMT

Fantastic. This is exactly what I'm looking for!