topic Re: More than one condition in QlikView

More than one condition

Thu, 05 Sep 2013 15:43:45 GMT

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 — Thu, 05 Sep 2013 15:51:39 GMT

Try

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

MayilVahanan — Thu, 05 Sep 2013 16:20:23 GMT

Try like this

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

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

Fri, 06 Sep 2013 10:15:08 GMT

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