Discussion Board for collaboration related to QlikView App Development.
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.
put the count on the outside:
count(If(ticket_age < 2, ticket_number) )
View solution in original post
That's what I needed. Thanks!