topic Re: Count while load in QlikView

Count while load

peterkumar — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

My input data has Client Exec and Meeting Status.

Meeting Status can be complete or incomplete.

There may be multiple records per Client Exec and each record will have one status - Complete or Incomplete.

I need to create a data set with one record for each Client Exec that shows the name and the number of completed meetings as well as the number of incomplete meetings.

I have tried the code below, but it is not working correctly -

LOAD
[Meeting Status],
[Client Executive Name],
If ([Meeting Status] = 'Completed',count([Meeting Status])) as Completed_Meetings,count([Meeting Status]) as Incomplete_Meetings

Resident PS17_DATA
Group By
[Client Executive Name],
[Meeting Status]
;

I will greatly appreciate your suggestions.

Thanks

Re: Count while load

sunny_talwar — Fri, 17 Feb 2017 20:50:58 GMT

Try this:

LOAD [Client Executive Name],
Count(If ([Meeting Status] = 'Completed', [Meeting Status])) as Completed_Meetings,

Count([Meeting Status]) as Incomplete_Meetings
Resident PS17_DATA
Group By [Client Executive Name];

Re: Count while load

peterkumar — Fri, 17 Feb 2017 21:31:18 GMT

Thanks Sunny.

You have led me to the right path.

LOAD

[Client Executive Name],
Count(If ([Meeting Status] = 'Completed', [Meeting Status])) as Completed_Meetings,
Count(If ([Meeting Status] = 'Incomplete',[Meeting Status])) as Incomplete_Meetings

Resident PS17_DATA
Group By [Client Executive Name];

The second If prevents from counting the Completed as Incomplete.

Thanks again!

Re: Count while load

sunny_talwar — Sat, 18 Feb 2017 01:53:09 GMT

Great

Please close this thread by marking correct and helpful responses

Qlik Community Tip: Marking Replies as Correct or Helpful

Best,

Sunny