topic Re: Correct Expression in QlikView

Correct Expression

Anonymous — Wed, 23 Dec 2015 10:12:30 GMT

I try to calculate the total patient in branch 'A' where Initial examination = 1

i try:

if(BranchID={'A'}) and ([has initial examination] = {'1'}), count(PaientID))

but it doesn't working.

Re: Correct Expression

roger_stone — Wed, 23 Dec 2015 10:14:29 GMT

Have you spelt PatientID correctly?

Re: Correct Expression

vikasmahajan — Wed, 23 Dec 2015 10:20:40 GMT

=Count( {< BranchID={'A'} ,[has initial examination] = {'1'} >} PaientID)

Re: Correct Expression

Wed, 23 Dec 2015 10:21:37 GMT

Maybe you can try this,

if((BranchID='A') and ([has initial examination] = 1), count(PaientID))

Re: Correct Expression

Chanty4u — Wed, 23 Dec 2015 10:24:59 GMT

u hve one extra brace....")"

please remove dis

Re: Correct Expression

Anonymous — Wed, 23 Dec 2015 10:27:04 GMT

You can try:

if(BranchID='A', count(Distinct {<[has initial examination] = {'1'}>} PaientID))

Also check the spelling of PaientID, are you sure it is not PatientID?

Re: Correct Expression

Wed, 23 Dec 2015 10:32:20 GMT

try this with and with out single quoates for 1

count({< BranchID={'A'} ,[has initial examination] = '1'>}PaientID)

Re: Correct Expression

settu_periasamy — Wed, 23 Dec 2015 10:49:11 GMT

May be like this

if(BranchID='A' and [has initial examination] = '1', count(PaientID))

Re: Correct Expression

tyagishaila — Wed, 23 Dec 2015 10:50:26 GMT

I hope, below expression must work.

=Count({< BranchID ={'A'}, [has initial examination] = {1} >} PatientID)

Correct Expression

Re: Correct Expression

Chanty4u — Wed, 23 Dec 2015 10:53:33 GMT

hi,

=Count({< BranchID ={'A'}, [has initial examination] = {'1'} >} PatientID)

Re: Correct Expression

sasikanth — Wed, 23 Dec 2015 11:31:54 GMT

hi,

try some thing like below

use if condition inside Count function

COUNT( IF ( BranchID='A' and ([has initial examination] = '1', PaientID) )

Re: Correct Expression

Anonymous — Wed, 23 Dec 2015 11:53:02 GMT

may be this:

=count({<BranchID={'A'},[has initial examination] = {'1'} >} distinct PaientID)

Re: Correct Expression

Wed, 23 Dec 2015 12:46:39 GMT

Hi Mohammed, you can try this four options:

=count({<BranchID={'A'}, [has initial examination] = {1} >} distinct PaientID)

=count({<BranchID={'A'}, [has initial examination] = {'1'} >} distinct PaientID)

if(BranchID='A' and [has initial examination] =1, count( distinct PaientID))

if(BranchID='A' and [has initial examination] ='1', count( distinct PaientID))

It depends if [has initial examination] is a string or number.

I hope that it help you!

Regards, Agustin

Re: Correct Expression

Wed, 23 Dec 2015 15:01:25 GMT

hi Mohmd,

i think below expression should work

=count({<BranchID={'A'},[has initial examination] = {'1'} >} distinct PaientID)

if not please share sample data to understnd the same properly