Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bsbernabe
Creator
Creator

two dashboard by selection in ranking file

How to make two dashboard by selection in ranking file in first dashboard for head/manage/supervisor and the second dashboard is for supervisor/rank & file if i select the manager suppose to be appear in second dashboard all the staff and supervisor under his group.

how can i do that.

Your support is highly appreciated,

Regards,

Bing

1 Solution

Accepted Solutions
Anonymous
Not applicable

Hi Bing,

Attached app may help you,

Steps

1)Created duplicate fields without manager data

2)created a key to avoid synthetic keys.

hope this may help you or look for hierarchy

!

View solution in original post

16 Replies
bsbernabe
Creator
Creator
Author

to clarify my concern the dashboard or chart is look like this below

if the manager is selected the output in chart or dashboard is like screenshot below

and the second dashboard or chart output is like screenshot below all under his GROUPCODE

i hope you understand what concern i have.

Thanks,

Bing

avinashelite

You could add a button and add 2 actions i.e.

1.for the 1st dashboard with the Manager selection and

2. For the 2nd with the GROUPCODE selection

bsbernabe
Creator
Creator
Author

Thanks for your support but the question is it is possible to make two chart one for the manager/supervisor detail and the other one is for supervisor and rank & file? like the screenshot i send that's the output the i need. but i think its possible but i don't know how to do.

Anonymous
Not applicable

Hi Bing,

Attached app may help you,

Steps

1)Created duplicate fields without manager data

2)created a key to avoid synthetic keys.

hope this may help you or look for hierarchy

!

avinashelite

yes, Create different charts and then in the 2nd chart (as per your screen shot) add a ignore condition in the set analysis for Name like this sum({<NAME>}1) this will ignore the manager selection in the 2nd chart

sunny_talwar

May be like this?

Capture.PNG

bsbernabe
Creator
Creator
Author

Yes Sunny Like that but i don't know how to do that or control each chart.

sunny_talwar

I used set analysis to do this... I guess you can use the similar logic, right?

bsbernabe
Creator
Creator
Author

will see can you send me your qvw.