topic Re: Graph Grouped Issue in QlikView

Graph Grouped Issue

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

Hello,

I have 1 Normal Graph. PFA

I attached 2 Graph's ..

1) Normal 2) Expected

Re: Graph Grouped Issue

jonathandienst — Mon, 30 May 2016 07:59:45 GMT

You need a stacked chart style.

Qlik Community Tip: Posting Successful Discussion Threads

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 08:01:11 GMT

I have one graph which name is Normal (PFA)

My output required which i attached the Expected (PFA)

Re: Graph Grouped Issue

kamal_sanguri — Mon, 30 May 2016 08:04:18 GMT

Hi,

In order to make Stacked Bar chart, you will need to add at lease two expressions..

that means you may have to make some changes in your data model.. i.e you have to make Voluntary and Non Voluntary as your column, currently they are the values of some other column..hope that make sense..

Attaching a sample QVW for you to review..

-Kamal

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 08:27:43 GMT

Kamal,

PFA of Sample..

First i want to show Year like 2014, 2015 and 2016

When i click on 2014 i want to show like Expected o/p (for reference Before attachment)...

Same as 2015, 2016

Re: Graph Grouped Issue

Anonymous — Mon, 30 May 2016 08:42:13 GMT

Hi Kamal,

Seems like you want to use both stacked and grouped bar charts, which I do not think is possible.

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 08:54:57 GMT

Hey there,

I guess what you require isn't possible with only one dimession in your chart. For a chart to be grouped or stacked you'll need more than one dimension and you have only one. Sorry mate

Regards,

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 09:13:54 GMT

Miguel,

Give me one example for that with 2 Dimensions. Please work on my qvw only.

And then try how it came. So that, i can use main task ...

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 09:18:16 GMT

See this example using your qvw please

Regards,

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 09:29:53 GMT

Miguel,

That i already applied. So finally what i would like to ask you one more question here.

Is this possible to rotate this graph. Above graph is Original - Now here i want to use Butterfly Graph. So, i want to change first graph to second graph ...

Like Mirror .. Please find Attachment ...!

Re: Graph Grouped Issue

kamal_sanguri — Mon, 30 May 2016 09:30:45 GMT

I added two more columns to your spreadsheet, used a basis formula to compute those so should not be a problem implementing it..

I could achieve it partially, it is the group which is causing the problem.. if I just take year as dimension.. it is working properly.. but as soon as I take group in dimension.. it stops working..

Re: Graph Grouped Issue

kamal_sanguri — Mon, 30 May 2016 09:32:45 GMT

the first chart works the way you want (but only year in dimension had to remove group to make it work).. pls select any year and check.. the second chart with group is not working..

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 09:34:18 GMT

The answer to your question is bellow this.

But let me remind you it's not quite what you have expected in the first place...

Regards,

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 09:40:50 GMT

Is there any chance / option to rotate the chart like above ...!

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 09:46:43 GMT

Refer to the atached file:

Regards,

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 09:48:04 GMT

Explanation:

Use Text Sort option in the properties of your bar chart, then change it from "A -> Z" to "Z -> A"

Regards,

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 09:49:10 GMT

Miguel,

Please try to look my image and they try ...

Re: Graph Grouped Issue

miguelbraga — Mon, 30 May 2016 09:50:15 GMT

I've looked to your image and my given qvw does that. See the image:

Re: Graph Grouped Issue

kamal_sanguri — Mon, 30 May 2016 09:53:19 GMT

Just wanted to show how chart behaving incorrectly.. when used group as a dimension (I am not sure.. if it's a bug).. but the idea was to decide and implement solution per our priorities.. if we can live without the grouping then we can have a dimension which can show the year wise distribution of attrition and then when we click on it can see their distribution...

Re: Graph Grouped Issue

Anil_Babu_Samineni — Mon, 30 May 2016 09:55:24 GMT

That is not a problem.

My requirement is like below ...