Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
clemmytang
Contributor III
Contributor III

Qlikview listbox, tab based on collective data

Hi everyone,

I have a Dashboard of which initially is portraying the individual performance for one client. So all the tabs updates, based on the selection made on the landing page as "always one selected value" was selected. However, for one tab, I would like to collectively list the information from everyone else who is a part of the Group that Client is in. How can I make it so once the Client's name is selected on the landing page and they go to the Group information page, it would also include the information in that Client's group? Right now the table is only listing the data for that Individual. I tried to "override locked field," but that did not work. There also has be be a flow from the client selected through all the pages, so there would have to always be one selected value.

Please see the attached image.
"Client" is based on the selection from the landing page. "Group" is the group that client is a part of.

Issue: Once a client is clicked on the landing page, wishing to display the other members' data in the Client's Group (Group 1) in the table, for this tab only, all other tabs reflect that client's individual performance. 
 

I apologize for the horrible mock-up. The data I have is confidential so I didn't have much time to make a dummy set.

Please advise.

 

Thank you all in advance and hope you are all healthy and safe! ☺
Clem

Labels (5)
5 Replies
billbois
Creator
Creator

Hi Clem,

My employer won't let me see your JPG, so this is kind of a guess but I think it's a two step process.

1. Create a variable that returns the selected client's Group. So it would be something like "=Only(Group1)".

2. Use set analysis to ignore the selected client and use the variable to select the group. So maybe: SUM({$<Client1=,Group1={'$(vVariable)'}>}Sales)

Of course, your variable and fields will have different names, but I think that's a concept to try. Hope it helps!

Bill

clemmytang
Contributor III
Contributor III
Author

2020-08-25 09_35_41-Photos.jpg

clemmytang
Contributor III
Contributor III
Author

How about now?

 

billbois
Creator
Creator

Yes, that's better. I think the variable and set analysis approach will work.

In the first step, I said to use "=Only(Group1)" for the variable, thinking that Group1 was the name of the field. Replace that with whatever the correct field name is, and do the same in the set analysis. Those sorts of details will have to be edited to use your data schema, but I think the overall idea is the way to go.

Brett_Bleess
Employee
Employee

Just in case, including following links on Set Analysis:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

https://help.qlik.com/en-US/qlikview/April2020/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

If @billbois got you what you needed, please be sure to close out the thread by using the Accept as Solution button on his post to give him credit for the help and let others know that worked.

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.