Help! - distinct keyword not working like i thought

[Anonymous]

I have a measure calculation..

Count(distinct {$

<BINFlagToday={1}>}

BIN)

my data looks like this

BIN    BINFlagToday      Emp       EmpFlagToday

123     1                           John       1

123     1                            Tom        1

123     1                           Jerry        1

this means that I have 3 employees in one position today at this moment.  I thought that the above measure would return 1, but it's returning 3 (I think).  how can I return only 1?

[swuehl]

Are you sure it's returning 3 or not?

Could you post a small sample QVW?

[#3]

Hi,

I have used the same above data in Qlikview , i am getting count as 1.Can you please check once.

Please refer the attachment.

[swuehl]

1 is correct, isn't it?

If your real application shows something different, I strongly assume that this is due to differences in your data / model.

[#5]

yes, 1 is correct.

[Anonymous]

I will have to analyze it a little further..  my data is more complex, so I must be missing something..

[Anonymous]

Thanks for the input.  it is returning what it should be.  the original excel file was incorrect in its calculation (I was using that as my original starting point).  we're going from an excel version to a qlik version.  the excel version was incorrect.

Thanks,

Maria

[Anil_Babu_Samineni]

Seems, Qliksense Frustrate on you

Can you try this for me?

Count({<BINFlagToday = {'1'}>} DISTINCT BIN)