Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Filtering in expression

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!

3 Replies
dennisnet
Valued Contributor III

Re: Filtering in expression

Try Jannemannen,

Try something like this:

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

Not applicable

Filtering in expression

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

Not applicable

Filtering in expression

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

Community Browser