Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
kanve_03
Contributor II
Contributor II

Two Dimensions with a single expression

hi can any one help me achieving the  below dashboard
where i had too get the data by manager and employee group by in bar chart level

on x- axis !

support 360.png

24 Replies
Not applicable

please can u share sample. what are your dimensions and expression?

kanve_03
Contributor II
Contributor II
Author

Here i am Having

managers in their team around 5 to 10 employees as below image
where delguercio is manager

others are emp

support 360.png

Not applicable

Yes so your two dimensions will be manager and employee. Could you pls post a sample qvw with expression and dimension then I could try making the chart like the pic I posted

kanve_03
Contributor II
Contributor II
Author

please find the attached file

Not applicable

which is employee name field and which is the manager name field?

kanve_03
Contributor II
Contributor II
Author

PDM last name is the Manager

employee is employee or you can use last name or name

Not applicable

Does this match your requirement?

kanve_03
Contributor II
Contributor II
Author

Ya Thats fine

Not applicable

Create bar chart with PDM Last Name & Employee as Dimensions

If you want chart to display manager name at first and then employee name only once manager name is selected then add condition getselectedcount(PDM Last Name)>0 in Employee dimemsion condition. Else ignore this step.

Add expressions MTTR - Sum([Issue Age] * [L1 MTTR Closures])/Sum([L1 MTTR Closures])/1440.0

Add second expression - 0

Disable legend from presentation tab

kanve_03
Contributor II
Contributor II
Author

could you please share the App so that i can look how you had created it

i am trying but i am not getting which as you had shared a pic