count is not correct

[arulsettu]

hi i am trying to count the policy so did like this

count(distinct employee_id).

and dimension is age band

like this

if(ME_AGE>=0 and ME_AGE<=6,'0-6',

     if(ME_AGE>=7 and ME_AGE<=18,'7-18',

     if(ME_AGE>=19 and ME_AGE<=30,'19-30',

     if(ME_AGE>=31 and ME_AGE<=45,'31-45',

     if(ME_AGE>=46 and ME_AGE<=60,'46-60',

     if(ME_AGE>=60,'60')))))) as age_band

but the result getting is not correct. while checking in db output is little differs in qlikview.

here i attached a sample app please check and let me know what i am doing wrong.

[arulsettu]

showing incorrect values

[arulsettu]

same value for every age. can u tell me what is the issue

Thanks

[jagan]

Hi,

Can you attach data and in which age bucket this employee (035) should park?

Regards,

Jagan.

[arulsettu]

small set of data is attached here

employee 035 is

age          count

19 to 30    4

31 to 46    6

[jagan]

Boss what is employee ID field name in your excel file?

Regards,

Jagan.

[arulsettu]

ME_EMP_ID AS EMPLOYEE_ID

[jagan]

Hi,

I didn't find that field in your file.  Create a qlikview file with this data and attach that file.

Regards,

Jagan.

[Anonymous]

Hi,

Check the current sections and Back end Filleting data too.

Regards,

Nagarjuna

[arulsettu]

please check this or i will upload new one

[arulsettu]

uploaded but it is under moderated