topic Re: Set Analysis Using Available Values in QlikView

Set Analysis Using Available Values

Wed, 22 Jul 2015 15:14:42 GMT

Hi everybody,

Is there a way to use set analysis (or something) on the available values in a field, not just what the user has selected? I'm trying to make a scorecard where the user will select an employee and see their productivity and compare that to everyone who has worked at that stations for the given time frame. For example, I want to select Employee1 and see how many hours that employee has logged (76). In this case, Employee1 has worked only on Station 2. I need a way to then see the hours for only Station 2 with the user necessarily selecting it.

Is something like this even possible?

Thanks,

Justin

Employee	Station	Date	Hours
Employee1	2	07/20/2015	4
Employee1	2	07/21/2015	4
Employee1	2	07/22/2015	8
Employee1	2	07/23/2015	4
Employee1	2	07/24/2015	4
Employee1	2	07/25/2015	8
Employee1	2	07/26/2015	5
Employee2	1	07/20/2015	6
Employee2	1	07/21/2015	5
Employee2	1	07/22/2015	4
Employee3	2	07/23/2015	8
Employee3	2	07/24/2015	7
Employee3	2	07/25/2015	5
Employee4	3	07/26/2015	5
Employee2	1	07/20/2015	6
Employee3	1	07/21/2015	7
Employee3	2	07/22/2015	7
Employee3	2	07/23/2015	7
Employee3	3	07/24/2015	8
Employee3	3	07/25/2015	8
Employee3	2	07/26/2015	5

Re: Set Analysis Using Available Values

MK_QSL — Wed, 22 Jul 2015 15:22:37 GMT

May be... Haven't tried...

=SUM({1<Station = P(Station)>}Hours)

Re: Set Analysis Using Available Values

MK_QSL — Wed, 22 Jul 2015 15:24:09 GMT

=SUM({<Employee = , Station = P(Station)>}Hours)

Re: Set Analysis Using Available Values

Qrishna — Wed, 22 Jul 2015 15:50:34 GMT

See attached.

Re: Set Analysis Using Available Values

Wed, 22 Jul 2015 19:41:00 GMT

Thanks for the reply, Manish.

What function does the P() serve? I've never used it before.

Re: Set Analysis Using Available Values

Wed, 22 Jul 2015 19:45:23 GMT

Thanks for the reply, krishna.

What I'm looking to do is make it so when the use selects Employee1, one object will show the 37 hours worked for that employee. Employee1 also only ever worked at station 2. I would like the other object to show the total hours for station 2, which would be 76 hours. If the use then selected Employee2, one object would show that Employee2 worked 21 hours. The other object would show 28 hours with the user having to select Station 1.

Re: Set Analysis Using Available Values

Qrishna — Wed, 22 Jul 2015 21:00:19 GMT

See attached.

let me know if thats the expected output.

Re: Set Analysis Using Available Values

Thu, 23 Jul 2015 18:22:46 GMT

Yes! Station={$(=only(Station))} was the piece that I couldn't figure out. Thanks!

Re: Set Analysis Using Available Values

Qrishna — Thu, 23 Jul 2015 18:33:09 GMT

Awesome. Happy Qliking.