topic Urgent Help Required - Bar Width Problem in QlikView

Urgent Help Required - Bar Width Problem

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

Hello,

I have two graphs, Please find image..

I want to show same width of second image. And same line..!

- Anil

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 06 Jun 2016 16:09:33 GMT

Please post a small qlikview document that demonstrates the problem.

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:23:44 GMT

Gysbert,

Thanks for attempting.

PFA.

I have two graphs. In that, second graph i want to increase my graph width same as first graph...

Re: Urgent Help Required - Bar Width Problem

settu_periasamy — Mon, 06 Jun 2016 16:20:37 GMT

May be 'Uncheck' the 'Show Legend' in the Dimension Tab

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Mon, 06 Jun 2016 16:24:13 GMT

But,

I want like below..

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 06 Jun 2016 16:37:03 GMT

Use F year as dimension in both charts.

In both charts use the same Bar Distance and Cluster Settings

In the bottom chart use these expressions:

if([F Year]=2014,-Count([Name of Leaver]),0)
if([F Year]=2014,-Count(Type),0)

On the Presentation tab of the bottom chart uncheck the option Suppress Zero-Values

Press the Shift and Ctrl keys down at the same time. You should see red outlines around the chart parts. Move the legend from the right to the top or to the bottom of the chart.

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:23:32 GMT

Helpful,

Updated :

Can you please look the qvw and Excel

I take two graphs here. So, Client want to show single graph only. If i want to move one graph client want to move whole graph. But, here i am facing problem like if i move one graph the graphs are going out...

1) Hires graph 2) Leaver graph.

For reference (Hires Graph):

Graph 1 (Dimensions are Start Date (iv Recruiting data) and Expression is count(candidate {iv Recruiting data})

For reference (Leaver Graph):

Graph 2 (Dimensions are Drill Down {ExitDate, BU/Department, Job Level, Job Title - From HR HC Leavers (named), Expression is Count(Name of Leaver) } )

So i want to create one graph with these two graphs...

------------------------------

Client don't want to create any buttons here. When ever we click on second graph she want to hide first graph only. And then she want to show the second graph replace to first graph

Please help me....

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Tue, 07 Jun 2016 03:50:19 GMT

Updated : is anyone trying my issue?

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Thu, 21 Dec 2023 20:23:57 GMT

Hello,

Finally, I got the issue..

So i have one more problem here.

Is there any way to remove the 0 on Y-Axis of the below graph. For ref -251 Value is the graph. If not possible, Tell me so that i can close this issue with the correct answer of GYSBERT

Please help me, I want to close this thread ASAP..

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 13 Jun 2016 15:18:41 GMT

I'm not sure what you want. Try setting the Axis Color and the Font color of the Expression axis to white (or 100% transparent). And on the Expressions tab click on the + in front of the expression, select Text Color and enter =Black() as Definition.

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Mon, 13 Jun 2016 15:48:28 GMT

Gysbert,

Did you get a chance to look which i attach previous conversation.

Leavers graph is there, Right?

In that, i don't want to show 0 from Y-Axis. Can you please help me for this

Note: Here, I don;t want to show only 0 left of all i want.

Is that possible?

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 13 Jun 2016 16:07:25 GMT

Sorry, but I simply don't understand what you posted above. Try explaining using different words. Or ask a friend too help you with your english.

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Mon, 13 Jun 2016 16:12:21 GMT

I Apologize for that. I am very poor in English..

Anyway, Please find below attachment. Might be you will clear.

I am asking you, Is this possible in Qlikview...

In that attachment i put cross mark in red. I want to show with out that ZERO.....

Re: Urgent Help Required - Bar Width Problem

ramasaisaksoft — Mon, 13 Jun 2016 16:28:51 GMT

Hi Anil,

You need to control both charts dimensions as same

i mean

Chart 1:-10 names in Dim1

Chart 2:-10 names in Dim1

then u will get both are same size.

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 13 Jun 2016 16:33:17 GMT

Put a text box over it

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Mon, 13 Jun 2016 16:35:39 GMT

That is the one way only, Right?

Sorry to extend this Thread, Last question - Is there any other way to show like above image?

I am waiting for last answer. I will close this thread..

Re: Urgent Help Required - Bar Width Problem

Gysbert_Wassenaar — Mon, 13 Jun 2016 16:57:09 GMT

I don't know of any other way, but that does not mean that there isn't any other way.

Re: Urgent Help Required - Bar Width Problem

Anil_Babu_Samineni — Mon, 13 Jun 2016 17:29:09 GMT

Thanks for your support