-
Re: Set Analysis Using Available Values
Manish Kachhia Jul 22, 2015 11:22 AM (in response to Justin Kelly)May be... Haven't tried...
=SUM({1<Station = P(Station)>}Hours)
-
Re: Set Analysis Using Available Values
Manish Kachhia Jul 22, 2015 11:24 AM (in response to Justin Kelly)or
=SUM({<Employee = , Station = P(Station)>}Hours)
-
Re: Set Analysis Using Available Values
Justin Kelly Jul 22, 2015 3:41 PM (in response to Manish Kachhia )Thanks for the reply, Manish.
What function does the P() serve? I've never used it before.
-
-
Re: Set Analysis Using Available Values
Krishna Nagulapally Jul 22, 2015 11:50 AM (in response to Justin Kelly)See attached.
-
set analysis.qvw 157.2 K
-
Re: Set Analysis Using Available Values
Justin Kelly Jul 22, 2015 3:45 PM (in response to Krishna Nagulapally)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
Krishna Nagulapally Jul 22, 2015 5:00 PM (in response to Justin Kelly)See attached.
let me know if thats the expected output.
-
set analysis.qvw 157.5 K
-
Re: Set Analysis Using Available Values
Justin Kelly Jul 23, 2015 2:22 PM (in response to Krishna Nagulapally)Yes! Station={$(=only(Station))} was the piece that I couldn't figure out. Thanks!
-
Re: Set Analysis Using Available Values
Krishna Nagulapally Jul 23, 2015 2:33 PM (in response to Justin Kelly)Awesome. Happy Qliking.
-
-
-
-