topic Re: stacked bars in QlikView

stacked bars

mohan2391 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

Please find the attached word document.

I have a bar chart with 2 expressions

1.avg(tat_approval)

2.avg(tat_creation)

and i want to show this data by a cyclic group of Month,Quarter,Year,Week and client also asked to show the segregation of data for different statuses(STATUS field) as well so i included that as 2nd dimension.

By default i'm getting a stacked bar with 2 bars(expressions) (Approval+Creation) with different bars for diff statuses. (Totally 10 stacked bars for 10 statuses under each month/week/year/quarter)

Now, what i want is can i show it as 2 stacked bars only under each month/week/quarter/year with stacked bars as statuses.

If possible, how can i achieve it ?

Re: stacked bars

adamdavi3s — Fri, 25 Nov 2016 08:28:52 GMT

can you share your application?

I feel like this is possible but can't quite picture it

Re: stacked bars

dineshm030 — Fri, 25 Nov 2016 08:42:45 GMT

Hi,

Can you attach your QVW file?

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 09:02:23 GMT

Here is QVW file.

Re: stacked bars

adamdavi3s — Fri, 25 Nov 2016 09:04:25 GMT

Is this correct?

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 09:11:18 GMT

Yeah,

This is super Adam.

But i hope using Calculated Dimension is not good when we look from Dashboard Performance.

So, is there any other approach if possible ?

Re: stacked bars

dineshm030 — Fri, 25 Nov 2016 09:25:18 GMT

Hi Mohan,

Your Bar Chart has already Stacked Bar.

Below is the image for your reference.

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 09:31:13 GMT

That is what I said Dinesh..

If you see October data, there are 9 stacked bars(1 stack for Approval, 1 stack for Creation) for 9 diff statuses.

But i want 2 stacked bars only under October, each contains 9 stacks (for 9 statuses). 1 for Approval, 1 for Creation.

Re: stacked bars

dineshm030 — Fri, 25 Nov 2016 09:43:32 GMT

Hi Mohan,

Do you want like this??

Re: stacked bars

adamdavi3s — Fri, 25 Nov 2016 09:45:08 GMT

I personally wouldn't worry too much about the calculated dimension if it works.. are you seeing a huge performance issue with it?

Re: stacked bars

vangurideepu — Fri, 25 Nov 2016 09:53:11 GMT

Hi Adam,

Please provide the expression for that....

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 10:13:39 GMT

I want as like in 1st one but there i want 9 stacks in each bar, showing how much 1 particular status(stack) is contributing into the Approval/Creation . . .

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 10:17:46 GMT

For now, i didn't face any issue as the development of this dashboard is started recently but in future they are planning to include many things in this.

Okay, anyhow i will follow this approach for now.

If i face any issues in future, need to look for some other solution.

Thank You for your support..

Re: stacked bars

mohan2391 — Fri, 25 Nov 2016 10:19:14 GMT

Thank You Adam and Dinesh for your support..

Re: stacked bars

dineshm030 — Fri, 25 Nov 2016 10:35:32 GMT

Hi Mohan,

I think, you want like this.