Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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
kanve_03
Contributor II
Contributor II
Author

Hi,

how to build a chart like this one
any help is appreciated, 

Anonymous
Not applicable

Hi see below app,

It may help you

Thanks

BKC

ramoncova06
Partner - Specialist III
Partner - Specialist III

you can use a combo chart or create a dimension that combines both fields manager&chr(13)&employee

kanve_03
Contributor II
Contributor II
Author

we need some calculation where you are having date
here i do wanna see sum(issues) according by manager and employee in group by as pic i posted
i am not with aggr
aggr should have one expression, if so what will be my exp when i use manager and emp

kamakshisuram
Creator
Creator

Hi Venkat,

You can use Trillis chart to get this done. Visually it looks different but this is nice option,

Capture.JPG

Not applicable

Hello! you should be able to achieve your desired result by adding a second expression to your bar chart . Second expression should just be 0. Now go to presentation tab and disable legend.

kanve_03
Contributor II
Contributor II
Author

I didnt get your point
how can my second expression can be 0
if any exp pls pass it

Not applicable

Please SEE ATTACHED PICTURE. In this case the two dimensions are Transaction Year and Transaction Month. The two expressions are sum(nsv) and 0. In your chart you need to add a second expression and just type 0 in expression definition. (see screen shot) . Next disable legend in properties>presentation (screenshot attached).

kanve_03
Contributor II
Contributor II
Author

ya but for me its different scenari

i have done same here but i cant get it
its showing blank
do i have to use any limitations  or any
i should get the employees names by group by pdm