topic Missing Bubbles in QlikView

Missing Bubbles

Anonymous — Tue, 10 May 2016 21:11:24 GMT

I have a bubble chart plotting the data parity status , what ever min and max values I have some bubbles seem to miss to Plot ... please take a look at the minimum date value 2/19 has the data parity status as Red but its not plotted .. can some one please let me know what min and max values I should set in order to NOT miss any bubble plots

Thank you!

Re: Missing Bubbles

swuehl — Tue, 10 May 2016 21:31:40 GMT

Well,

you are filtering out Ingestion Date that are older than 60 days, so no wonder these are not shown in the chart?

=sum(if([Ingestion Date] >=today()-60,[Ingestion Date]))

Re: Missing Bubbles

Anonymous — Tue, 10 May 2016 21:48:08 GMT

Oops! my bad .. sorry .. I forgot that I made that change recently ...but why am I seeing 2/15 the start date should be 3/11 right?

I see the all the bubbles seem to be clamped towards right side can we adjust to make sure they are spread out evenly?

Re: Missing Bubbles

swuehl — Tue, 10 May 2016 21:51:25 GMT

What do you mean with clamped towards right side?

I see this:

Re: Missing Bubbles

Anonymous — Tue, 10 May 2016 21:58:04 GMT

Not sure why you are seeing values for 2/15 in the attached application the chart looks like below, no bubbles between 2/15 - 3/1 .. how do I make the chart start from past 60 days only .. I mean I want the x axis dates to start from 3/11 as of today.

Re: Missing Bubbles

swuehl — Tue, 10 May 2016 22:18:44 GMT

If you want to start from ealiest 60 days before today, set the static min for x-axis on axes tab accordingly:

=RangeMax(MIN([Ingestion Date])-1,today()-61)

Re: Missing Bubbles

Anonymous — Tue, 10 May 2016 22:30:35 GMT

Great .. THANK YOU!