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.

[sudeepkm]

I see there is a single quote missing in the below expression: Order={ITDepartment'}

Can you please verify it? Or please post a sample QVW.

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

[#3]

Thanks. sorry it is a typo mistake. in the file i haven't missed anything.

[MK_QSL]

Count({$<

               Source = {'ITDepartment'},

               Order = {'ITDepartment'},

               Result = {'Work Completed'},

               Flag = {1}

          >}DISTINCT EmployeeID)

I don't think so this will affect your end result. But try it at least once.

OK... let us have your sample apps.

[er_mohit]

Try to change expression like this

make sure Date Format is same .

Count( {$<DateField={'>=$(=Date(Min(Datefield)))<=$(=Date(Max(Datefield)))'},Source={'ITDepartment'},Order={ITDepartment'},Result={'Work Completed'},Flag={1}>}EmployeeID)

[sudeepkm]

That's strange because if you are saying that in your database table the count returns 5 EMP IDs and in QlikView even after you do distinct the count is 10.

I think it would be easy if you can post the QVW. The expression looks fine to me. I need to know how the table is created in QlikView after you loaded it from DB.

[#7]

Please see attached as this is sample data.so, it is showing 5. but actually in my original file it is showing 10

[#8]

HI

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

[#9]

Thanks and it's not working. Any help

[#10]

Thanks. same it's not working