topic Re: Filtering in expression in QlikView

Filtering in expression

Fri, 06 May 2011 07:18:16 GMT

Hello!

I'm trying to filter my data in the expression as example below:

Sum({$< Year = {"2010"}>}ABC)

This works fine. However, when I try to add another filter I just can't seem to get it right... I've tried many variations of bellow:

Sum({$< Year = {"2010"}>} and {$< Customer = {"AAA"}>} ABC)

(I want to show only ABC values where the Year is 2010 and Customer is AAA)

Is there any way of doing this? I belive I'm just not using the correct syntax.

Thanks in advance!

Anonymous — Fri, 06 May 2011 07:33:39 GMT

Try Jannemannen,

Try something like this:

Sum( {$<Year={"2010"}, Customer = {"AAA"} >} ABC)

Fri, 06 May 2011 07:37:45 GMT

Hi,

Try this, this should work.

Sum( {$<Year={2010}, Customer = {'AAA'} >} ABC)

BTW.. New look & feel of the community is owesome..!! I like this.. (nope)..Double like

- Sridhar

Fri, 06 May 2011 07:48:00 GMT

Thanks for the quick respone.

With your input I managed to solve my problem using the folloing:

Sum( {$< Year = {"2010"}, Customer = {"AAA"} >} ABC)

Thanks again