Set Analaysis, Select Dataset from selected field

Anonymous — Tue, 14 Jun 2016 20:31:55 GMT

I currently have a dashboard with a table that has an account. This account can have multiple users that touch the account so the data reflects that. I also have a table next to it that lists the users and some other info. I am trying to make it so that when a user clicks on a username in the table on the right, the table on the left will show all detail for any user that has touched it as long as the one i selected on the right also touched it.

Example:

Account

Account	Date	User
k001	1/1/2012	Mike
k001	1/2/2012	Shawn
k001	1/3/2012	Steve
k002	1/4/2012	Dave
k002	1/4/2012	Nigel

If i select mike from the right table, i want all the records for account k001 to show up.

I currently have this

Count({$<AccountNumber=P({1<InterventionActivityUser_UnvUserID={$(='Mike')}>}AccountNumber)>}AccountNumber)

It works, but i need to not have it be hardcoded. I have played around a bunch and i hope this is something simple. Any help would be awesome!

Re: Set Analaysis, Select Dataset from selected field

sunny_talwar — Tue, 14 Jun 2016 20:39:44 GMT

How about this:

Count({$<AccountNumber=P(AccountNumber), InterventionActivityUser_UnvUserID = >}AccountNumber)

Re: Set Analaysis, Select Dataset from selected field

Anonymous — Tue, 14 Jun 2016 20:41:01 GMT

I ❤️ you

topic Re: Set Analaysis, Select Dataset from selected field in QlikView

Set Analaysis, Select Dataset from selected field

Re: Set Analaysis, Select Dataset from selected field

Re: Set Analaysis, Select Dataset from selected field