topic Re: Proper format for 'or' expression statement in QlikView

Proper format for 'or' expression statement

Fri, 25 Oct 2013 14:09:49 GMT

I'd like to count records when defect starts with 'F' or ChargeDept starts with 'P'. I've tried the following and a few variations with no success.

= Count({<T_Defect = {'F*'}>} or {<T_ChargeDept = {'P*'}>} T_TrackingID)

Also, what would be the format if I wanted to list some ChargeDepts instead of using the like statement. Is there somewhere good to go for reference on how to set up these statements - I seem to be getting tripped up a lot on this formatting - not like anything I've done before.

Re: Proper format for 'or' expression statement

Jason_Michaelides — Fri, 25 Oct 2013 14:11:01 GMT

Try:

Count({<T_Defect = {'F*'}>} + {<T_ChargeDept = {'P*'}>} T_TrackingID)

Re: Proper format for 'or' expression statement

MayilVahanan — Fri, 25 Oct 2013 14:12:04 GMT

Try like this

Count({<T_Defect = {'F*'}>} + {<T_ChargeDept = {'P*'}>} T_TrackingID)

Hope that helps

Re: Proper format for 'or' expression statement

Fri, 25 Oct 2013 14:21:47 GMT

I'm getting an error in expression message starting with the second {. Hopefully image comes though. Also would this expression double-count if a record meets both criteria - the intention would be to count only once. Thanks for the help.

Re: Proper format for 'or' expression statement

Jason_Michaelides — Fri, 25 Oct 2013 14:25:11 GMT

No, I don't think it will double-count.

Sorry - you shouldn't close the {} before the +:

Count({<T_Defect = {'F*'}>+<T_ChargeDept = {'P*'}>} T_TrackingID)

Re: Proper format for 'or' expression statement

Fri, 25 Oct 2013 14:30:43 GMT

You were right - it did not double count. Can you give me the format if I wanted to list several ChargeDept instead of using the like statement?

Also, is there a good place to go look at some examples for these type things. I looked through the reference manual pretty quickly but did not see anything.

Re: Proper format for 'or' expression statement

Jason_Michaelides — Fri, 25 Oct 2013 14:39:05 GMT

Count({<T_Defect = {'F*'}>+<T_ChargeDept = {'P','OtherDept1','OtherDept2','etc'}>} T_TrackingID)

I think the F1 help is pretty good for Set Analysis, otherwise there's loads of stuff in here. There's even a Set Analysis Expression Builder app somewhere...