topic Re: Error in Expression in QlikView

Error in Expression

Anonymous — Thu, 11 Dec 2014 23:19:36 GMT

Can anyone assist with tracing the error in the following expression:

Count(DISTINCT({<[Doctor Name]={'PIM'}>}[Script Number])) + Count(DISTINCT({<[Doctor Name]={'PID'}>}[Script Number]))

Regards

Thu, 11 Dec 2014 23:22:20 GMT

Change like this.

=Count (distinct {<[Doctor Name]={'PIM'}>}[Script Number]) + Count( distinct {<[Doctor Name]={'PID'}>}[Script Number])

"Distinct" is not a function.

Anonymous — Thu, 11 Dec 2014 23:22:27 GMT

you have extra brackets: no brackets necessary after distinct...try this

Count(DISTINCT {<[Doctor Name]={'PIM'}>}[Script Number]) + Count(DISTINCT {<[Doctor Name]={'PID'}>}[Script Number]))

rwunderlich — Thu, 11 Dec 2014 23:23:51 GMT

I would say that Set expression comes before the DISTINCT keyword like this:

Count({<[Doctor Name]={'PIM'}>} DISTINCT [Script Number]) + Count({<[Doctor Name]={'PID'}>} DISTINCT [Script Number])

-Rob

Anonymous — Thu, 11 Dec 2014 23:34:58 GMT

Hi Rob

Many thanks, you are right, that works.

Regards.

Chris

Anonymous — Thu, 11 Dec 2014 23:35:47 GMT

Many thanks, I used Rob's recommendations.

Anonymous — Thu, 11 Dec 2014 23:36:20 GMT

Many thanks. I used Rob's recommendations