topic Re: Issue with Y-axis dimension layout in QlikView

Issue with Y-axis dimension layout

neetu_singh — Fri, 11 Dec 2015 08:35:54 GMT

Dear All,

I need the Y-axis dimension layout as per the "requirement" image but in qlikview am getting like "getting" image.

Is there any way so that I can get as per the "requirement" image.

Please suggest.

Re: Issue with Y-axis dimension layout

Anonymous — Fri, 11 Dec 2015 08:41:31 GMT

can you share a sample file?

Re: Issue with Y-axis dimension layout

tresB — Fri, 11 Dec 2015 08:42:14 GMT

45910, 60910 bars are of same height? Or is it about showing the values at the bottom? If so, check my solution here: How to show data points at bottom

Re: Issue with Y-axis dimension layout

its_anandrjs — Fri, 11 Dec 2015 08:53:49 GMT

You can create the text objects for all four dimensions with the trick and place over the chart.

Regards

Anand

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 11 Dec 2015 10:01:56 GMT

Hi Tresesco,

i tried the same but getting value "1" only.

Can you please try the same in my sample file & if possible can you please look into the left hand side dimension layout as well.

Re: Issue with Y-axis dimension layout

tresB — Fri, 11 Dec 2015 10:49:06 GMT

Number tab->Select the expression ->Set the format to 'Expression Default'

Did it for one exp. PFA

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 11 Dec 2015 11:59:14 GMT

It's not coming with in the bar nd if we try for two expression then it's overriding to the first one.

Re: Issue with Y-axis dimension layout

neetu_singh — Mon, 14 Dec 2015 07:20:31 GMT

Hi All,

Can we get the left side layout same as "getting" image.

Re: Issue with Y-axis dimension layout

tresB — Mon, 14 Dec 2015 08:50:21 GMT

Like:

Re: Issue with Y-axis dimension layout

neetu_singh — Mon, 14 Dec 2015 09:07:23 GMT

No, something like as shown below -

Re: Issue with Y-axis dimension layout

tresB — Mon, 14 Dec 2015 10:10:22 GMT

Check the attached qvw, you would get the logic I believe. Some coloring and alignment you might have to play with that you could be able to manage.

Re: Issue with Y-axis dimension layout

neetu_singh — Mon, 14 Dec 2015 10:46:51 GMT

Shared image and qlikview are not same.

I mean in attached qvw not getting the same as per the attached image.

But I'll try the logic which you have shared.

Re: Issue with Y-axis dimension layout

tresB — Mon, 14 Dec 2015 10:57:05 GMT

This?

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 18 Dec 2015 08:01:49 GMT

Hi Tresesco,

If we are using 2 dimension in that case, we are not getting value at the bottom within Bar.

Any suggestion.

Re: Issue with Y-axis dimension layout

tresB — Fri, 18 Dec 2015 08:46:30 GMT

Hi,

What about the layout thing I showed above; did that help (I am curious since you did not mark it so)? Well, try to share a sample qvw that demonstartes the issue (I am too lazy to create my own sample and do the R&D ).

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 18 Dec 2015 09:23:06 GMT

Hi Tresesco,

I tried in a same way but was not able to achieve the same. So have added the same with in my expression.

Please find the sample file to get the data point at the bottom of bar chart & suggest.

Re: Issue with Y-axis dimension layout

tresB — Fri, 18 Dec 2015 09:29:57 GMT

Did you check my attachment - 'testqv2_tres4.qvw' ?

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 18 Dec 2015 09:50:58 GMT

Yes but in your attachment values are not coming within the bars.

Re: Issue with Y-axis dimension layout

tresB — Fri, 18 Dec 2015 10:03:50 GMT

What is your qv version?

Re: Issue with Y-axis dimension layout

neetu_singh — Fri, 18 Dec 2015 10:13:51 GMT

QV11.2 SR10.

Can you share the screen shot for the output which you are getting in testqv2_tres4