topic Re: Counting Tasks Help in QlikView

Counting Tasks Help

bazzaonline — Tue, 20 Jan 2015 14:20:20 GMT

Hello, I have some data which is a list of people and a list of different tasks they have completed. For example

Name Task

Fred Cleaning

Fred Hoovering

Jane Washing

Fred Cleaning

Jane Cleaning

Fred Hoovering

How can I write an expression or a formula that will count the number of times the people have done different tasks,

For example

Name Cleaning Hoovering Washing

Fred 2 2 0

Jane 1 0 1

Thanks Paul

Re: Counting Tasks Help

alexandros17 — Tue, 20 Jan 2015 14:26:01 GMT

Load your data then add a chart (straight table) then

add Name and task as dimension

add the following expression: Count(Task)

let me know

Re: Counting Tasks Help

nirmalraj_kj — Tue, 20 Jan 2015 14:29:22 GMT

try like this

take dimension as Name and task in pivot

and write the expression like count(task)

then drag and drop the task as horizontal

try like this

take dimension as name

then write the expression like

Cleaning: Count({<Task={"Cleaning"}>}Task)

Hoovering: Count({<Task={"Hoovering"}>}Task)

Washing: Count({<Task={"Washing"}>}Task)

Hope this will helps you

Thanks & Regards

Nirmal

Re: Counting Tasks Help

nikhilgarg — Tue, 20 Jan 2015 14:47:07 GMT

HEy ,

I am trying to drop column task as horizontal but cann't do it. Can you please tell me how to make taks column horizontall ??

Thanks

Re: Counting Tasks Help

nirmalraj_kj — Tue, 20 Jan 2015 14:48:11 GMT

are you using pivot table or straight table?

Re: Counting Tasks Help

nikhilgarg — Wed, 21 Jan 2015 11:50:16 GMT

I am using Straight Table

Re: Counting Tasks Help

nirmalraj_kj — Wed, 21 Jan 2015 11:52:47 GMT