Expression error?

[#1]

Hi,

I have dimension and expression as below in straight table

Dimension: TeamMember

Expression: Count(DISTINCT {$<Source={'ITDepartment'},Order={ITDepartment'},Result={'Work Completed'},Flag={1}>}EmployeeID)

when I select the Date from 03/03/2014 to 07/03/2014 the count of the expression is showing 10 whereas in the database the count is showing 5. can anynone please tell me is there anything wrong in expression?

Thanks.

[ashwanin]

Expression seems to be perfect. Might be you have to check the database for this time frame for the respective entries.

[er_mohit]

See the attached file

your data is ok there's only 5 id for Result={'Work Completed'}

[#4]

hi

try to write in same date format like this

SUPPOSE YOUR DATE FORMAT IN 'DD-MM-YYYY'

THEN TRY THIS

Count(DISTINCT {$<Date={">=$(=Date(min(Date),'DD-MM-YYYY'))<=$(=Date(max(Date),'DD-MM-YYYY'))"}Source={'ITDepartment'},Order={ITDepartment'},Result={'Work Completed'},Flag={1}>}EmployeeID)

[MK_QSL]

There is definitely a problem in your DATE dimension.

If you create a list box for Date you can see multiple occurrence of the same Date...

Looking wrong...

[#6]

Thanks. this is sample data so it is showing 5 but in the original file it is showing 10. the database table data is also ok. it seems really strange. any ideas?

[senpradip007]

Can you attach original application?

[#8]

Yes you are right. but I joined this date with clendar date. so in the original file it is taking only single occurance. Any help please

[MK_QSL]

We can help only if you give us either proper sample data file or your sample apps as the expression is looking right.

[sudeepkm]

I see 5 records from your QVW but you said you found 10 records for the selections you described. Am I missing something?

[#11]

Hi,

can you upload your qvw?

MC