Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Syntax Error

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.

EK

2 Replies
swuehl
MVP
MVP

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).

Not applicable
Author

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