topic Re: Two Dimensions with a single expression in QlikView

Two Dimensions with a single expression

kanve_03 — Tue, 28 Apr 2015 14:32:17 GMT

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 !

Re: Two Dimensions with a single expression

kanve_03 — Tue, 28 Apr 2015 14:33:37 GMT

Hi,

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

Re: Two Dimensions with a single expression

Anonymous — Tue, 28 Apr 2015 14:39:39 GMT

Hi see below app,

It may help you

Thanks

BKC

Re: Two Dimensions with a single expression

ramoncova06 — Tue, 28 Apr 2015 14:43:09 GMT

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

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 02:48:02 GMT

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

Re: Two Dimensions with a single expression

kamakshisuram — Wed, 29 Apr 2015 05:47:39 GMT

Hi Venkat,

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

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 07:18:39 GMT

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.

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 07:22:13 GMT

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

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 07:41:20 GMT

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).

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 07:59:32 GMT

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

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 08:02:03 GMT

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

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 13:01:43 GMT

Here i am Having

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

others are emp

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 13:04:35 GMT

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

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 13:09:58 GMT

please find the attached file

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 14:02:51 GMT

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

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 14:14:21 GMT

PDM last name is the Manager

employee is employee or you can use last name or name

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 15:19:15 GMT

Does this match your requirement?

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 16:09:33 GMT

Ya Thats fine

Re: Two Dimensions with a single expression

Wed, 29 Apr 2015 16:29:29 GMT

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

Re: Two Dimensions with a single expression

kanve_03 — Wed, 29 Apr 2015 16:31:24 GMT

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