Syntax Error

Tue, 20 Nov 2012 14:00:15 GMT

I recieved help from Gysbert Wassenaar on this formula. Thank you Gysbert. It is showing syantax error I am wondering if anyone knows what needs to be changed.

Count({<AMOUNT={'>0'},[Proc code]-={'9929*'}>+<AMOUNT={'>0'},[Proc code]={'99291'}>} DISTINCT(DOS&'-'&PAT_ENC_CSN_ID&'-'& [Proc Code]&'-'&[Prov ID]))

"It should count all records where AMOUNT > 0 and Proc code doesn't start with 9929, unless it's 99291"

The underlined error is where the syntax error is located. If I take out the minus sign before ={'9929*'} the formula works but would include when I need it to exclude. I have also tried double quotes around the wildcard and that makes no difference.

Basically I want these proc codes counted-

99281

99282

99283

99284

99285

99291

I do not want proc code 99292 counted.

Any help is appreciated.

Re: Syntax Error

swuehl — Tue, 20 Nov 2012 14:04:04 GMT

I think that (i.e. the red underlining) is just a bug in the syntax checker, just ignore it (it should say 'Syntax ok' or something similar in the dialog above the entry field).

Re: Syntax Error

Tue, 20 Nov 2012 14:13:17 GMT

It does. Good to know I should go by the dialog box. Thanks

topic Re: Syntax Error in QlikView

Syntax Error

Re: Syntax Error

Re: Syntax Error