topic AW:Hiding rows in table in QlikView

Hiding rows in table

Wed, 02 Dec 2009 16:48:56 GMT

Hi,

I've got a problem in a pivot Table with products, months and sum sales. I need a additional column with the sales per jear for each month.

So far so good thats easy with set analysis: sum( {$<Monat_OrderDate=>} total<Product> Sales)

But when I select some months in the list box. I want to see only those lines with sum(sales) > 0.

How can I do this?

Have Fun With QV

Alex:)

Wed, 02 Dec 2009 16:58:18 GMT

Modify the formula e.g. like this:


IF([Sum(Sales)]>0, sum( {$<Monat_OrderDate=>} total<Product> Sales))

Kind regards.

Wed, 02 Dec 2009 17:10:49 GMT

Thaks a lot,

I had a mental block!

Have Fun With QV

Alex #-)