More than one condition

[#1]

Hello,

I'm new to Qlikview and not able to solve this problem dispite searching this forum. It's probably simple but not for me !

I have a simple table like this :

Action       Type          TaskCount

R               Type1               3

R               Type2               6

C               AnoterType       7

C               Type2                2

R               AnotherType     1

I would like to count in a chart only the rows where Action = 'R' AND Type = 'Type*'... Here it would be 2 for example.

Expression looks like this :

Count({<Action={"R"}>} TaskCount)

Now how do I add the second condition to this expression ?!? I've tried with 'and', bracket [ ], etc. but did not figure it out yet ?

Many thanks for your much appreciated support. I think it's a great tool by the way.

Luc

[swuehl · Accepted solution]

Try

count ({<Action = {R}, Type = {"Type*"} >} TaskCount )

[MayilVahanan]

Hi

Try like this

count ({<Action = {R}>*<Type = {"Type*"} >} TaskCount )

or

count ({<Action = {R}, Type = {"Type*"} >} TaskCount )

[#4]

Thanks to both of you, it's perfect : actually I had another issue which is also fixed by these two expressions :

count ({<Action = {R}, Type = {"Type*"} >} TaskCount )

-> this one is not updated when changing the selection

count ({<Action = {R}>*<Type = {"Type*"} >} TaskCount )

-> this one is updated if I change the selection

Not sure really why but I will for sure need both !

Thanks for your quick response and great support.

Luc