topic Need help with conditional statement in pivot table in QlikView

Need help with conditional statement in pivot table

Thu, 06 Oct 2011 20:32:50 GMT

I have the following data:

I'm trying to create a pivot table like this:

My dimension is locations, however, I can't seem to do a conditional expression correctly to get me the counts I needed.

I tried If(ticket_age < 2, count(ticket_number)) which doesn't work.

Any suggestions?

Thu, 06 Oct 2011 20:59:27 GMT

put the count on the outside:

count(If(ticket_age < 2, ticket_number) )

Thu, 06 Oct 2011 21:10:29 GMT

That's what I needed. Thanks!