topic How to filter on an expression in a chart ?? in QlikView

How to filter on an expression in a chart ??

Wed, 29 Dec 2010 16:18:22 GMT

Hi,

Here is my problem :

Got a chart with the following datas :

Code Production_Month_M-1 Production_Month_M
AAA 48 0
BBB 15 16
CCC 12 0
DDD 7 5

I would see only the line with a Production_Month_M =0

I tried this expression :

=if((sum({$<Month={$(VMonthM)}>}[production.PROD]))=0,(sum({$<Month={$(VMonthM)}>}[production.PROD])))

and i have :

Code Production_Month_M-1 Production_Month_M
AAA 48 0
BBB 15 -
CCC 12 0
DDD 7 -

instead of :

Code Production_Month_M-1 Production_Month_M
AAA 48 0
CCC 12 0

Thanks for your help !!!

How to filter on an expression in a chart ??

Wed, 29 Dec 2010 16:30:08 GMT

You need to put the same Set Analysis filter on the first expression. By default, QlikView will suppress rows where all expressions are null. Since you have values on the first expression for those records, they are displaying, even when the second expression is null.

Maybe:

=if((sum({$<Month={$(VMonthM-1)}>}[production.PROD]))=0,
 (sum({$<Month={$(VMonthM-1)}>}[production.PROD])))

I'm not sure what your expression is for the first expression, so that is a bit of a guess.

How to filter on an expression in a chart ??

Wed, 29 Dec 2010 16:41:42 GMT

Ok ! that's working !

thank you so much !!!

How to filter on an expression in a chart ??

Fri, 18 Mar 2011 06:48:14 GMT

What if I have a very wide tables with 10+ columns, does that mean I have to put that Logic in every single column?