Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

miscount

Hello ,

I have a chart which has the count of employees

12 Replies
Highlighted
Champion
Champion

Re: Count of emp miscount

which one is your date field??

Highlighted
Partner
Partner

Re: Count of emp miscount

Hi,

Can you explain little more and give expected output?

-Nagarjuna

Highlighted
Not applicable

Re: Count of emp miscount

Thanks Balraj

RS_DT is the date field

Highlighted
Not applicable

Re: Count of emp miscount

Hello Nagarjuna thanks for the reply

requirement is i need to get the count of employees as 74 but now i am getting as 99.

I need to correct the number and requesting your help on this

Highlighted
Specialist
Specialist

Re: Count of emp miscount

Try this-

Take discount count of employees.. might be your data has duplicate records..

Sreeni

Highlighted
Not applicable

Re: Count of emp miscount

Hello

if you see the expression in the chart its already applied distinct.

Highlighted
Specialist
Specialist

Re: Count of emp miscount

Hi

On what we should calculate count of employees.

Could you please clarify ?

Highlighted
Not applicable

Re: Count of emp miscount

Hello rgv

in the chart expression,we have the conditions to apply the count

please open the attachment

Highlighted
Partner
Partner

Re: Count of emp miscount

Hi ,

in which year you want count 74 2014 or 2015 .for 2014 its giving 73 Count .

As per ur data in your dashboard its giving correct.

are you sure ,after reloading its giving correct count . If yes .Did you save after reloading your application.again if yes ,Create new app and copy same script reload it and save.

Some times becoz of Bugs this situation come.

-Nagarjuna