topic Re: counting only when an other field starts with a certain letter in QlikView

counting only when an other field starts with a certain letter

Tue, 15 Jul 2014 12:30:40 GMT

I want to count all the actions where the code starts with a P,

the P is followed by different numbers.

What is incorrect in my expression?

count(distinct if(match(project_actions_code,'P%'),action_id))

alexandros17 — Tue, 15 Jul 2014 12:35:22 GMT

Match tells if P is contained in the string, use this expression instead:

count(distinct if(Index(project_actions_code,'P')=1,action_id, null()))

count({$ <project_actions_code={'P%'}>} distinct action_id)

let me know

Tue, 15 Jul 2014 12:37:47 GMT

The code starts with a P or an A followed by numbers.

I only want to count the actions where the code starts with a P, without regard wich numbers follow the P

alexandros17 — Tue, 15 Jul 2014 12:42:00 GMT

Ok, what about the code I sent to you?

Tue, 15 Jul 2014 12:42:32 GMT

Replace % by *

count({$ <project_actions_code={'P*'}>} distinct action_id) is the most efficient,

set analysis is more efficient than if clauses,

cheers

Tue, 15 Jul 2014 12:44:35 GMT

The first expression works!

The second one only gives me zero's.

It solved my problem, thanks!

Tue, 15 Jul 2014 12:52:46 GMT

Unfortunatly the set analysis doesn't work, the if-analysis does work