topic Fixing the Chart in QlikView

Fixing the Chart

Anonymous — Fri, 08 Apr 2016 17:38:12 GMT

I have a bubble chart with 2 issues ,

1. the Bubbles are being chopped off at the axis

2.pop up label shows "=" sign

Is there a way that I could fix these ? I have gone through some community post and looks like this is some bug kind of .. can someone please confirm that's there is no way this can be fixed ? Attached my App

Thank you

Re: Fixing the Chart

sunny_talwar — Fri, 08 Apr 2016 17:43:36 GMT

Not sure if I have an answer for your 1st question. But for 2nd point, may be create a field in the script: Dual('', RecId) as NewField

and use NewField in the chart as dimension

Re: Fixing the Chart

Anonymous — Fri, 08 Apr 2016 17:59:18 GMT

I did that I still see "=" as a pop up label when I hover over the bubble

and also is there a way that I could enable the scroll bar for X Axis?

Please take a look at my attached file , I have that dual expression in Dimension .. but I even move it to Script .. but still "=" remains 😞

Re: Fixing the Chart

sunny_talwar — Fri, 08 Apr 2016 18:03:50 GMT

Can you share the new application where you added the new column?

Re: Fixing the Chart

Anonymous — Fri, 08 Apr 2016 18:11:07 GMT

Attached !

Re: Fixing the Chart

sunny_talwar — Fri, 08 Apr 2016 18:21:43 GMT

Not able to get all three of done

May be someone else can chip in. Sorry

Re: Fixing the Chart

rubenmarin — Fri, 08 Apr 2016 18:24:54 GMT

Hi ramya, for the first one, in chart properties-->axis tab, can you set the Y axis static min to -0.04 or some value like this one and check if that fits your requirements?

If it needs to change with selections you can set: Min([Completed At])-0.04

Also the same can work for static max.

Hope this helps!

Re: Fixing the Chart

Anonymous — Fri, 08 Apr 2016 18:29:28 GMT

Thank you .. I was able to fixes the bubbles with Static Mon and Max .. hopefully someone will have alternates for scroll bar and pop label issues ..

Re: Fixing the Chart

rubenmarin — Fri, 08 Apr 2016 18:47:26 GMT

For the label, as an alternate, it doesn't looks bad is you show the summary there, can you check it?

Labeling the dimension as Summary and using:

=dual(Summary,RecId)

Or another info that can make an use of that '='

About the scroll bar, I don't know how to enable the check box on presentation tab, I tried some ways to disable the continous X axis unsuccessfully. Hope someone can help you with this one.

Re: Fixing the Chart

Anonymous — Fri, 08 Apr 2016 21:48:26 GMT

By the way .. I have a value above 6:00 pm which cannot be seen how do I make sure I am not missing any dots ?

Re: Fixing the Chart

rubenmarin — Mon, 11 Apr 2016 09:02:08 GMT

Hi ramya, setting the min axis as -0.04 and the max to 1.14 you can fix the Y axis to cover all day.