Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
arulsettu
Master III
Master III

count is not correct

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.

50 Replies
arulsettu
Master III
Master III
Author

showing incorrect values

arulsettu
Master III
Master III
Author

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

Thanks

jagan
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.

arulsettu
Master III
Master III
Author

small set of data is attached here

employee 035 is

age          count

19 to 30    4

31 to 46    6

jagan
Partner - Champion III
Partner - Champion III

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

Regards,

Jagan.

arulsettu
Master III
Master III
Author

ME_EMP_ID AS EMPLOYEE_ID

jagan
Partner - Champion III
Partner - Champion III

Hi,

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

Regards,

Jagan.

Anonymous
Not applicable

Hi,

Check the current sections and Back end Filleting data too.

Regards,

Nagarjuna

arulsettu
Master III
Master III
Author

please check this or i will upload new one

arulsettu
Master III
Master III
Author

uploaded but it is under moderated