topic Re: Chart Question in QlikView

Chart Question

Anonymous — Thu, 07 Apr 2016 21:30:40 GMT

I Need to create a chart as below , but not sure which type of chart I need to use , attached is my application with some sample data and here is the condition for coloring the dots:

If ingestion completed after 11:00 am, color the dot red
If ingestion completed before 11:00 am then

if data parity is green, then color the day/dot green

If data parity is yellow or red, then color the day/dot red

Re: Chart Question

swuehl — Thu, 07 Apr 2016 22:14:08 GMT

Maybe like attached?

I've used a calculcated dimension made of date and time as key, you probably should use something more meaningful.

Re: Chart Question

Anonymous — Thu, 07 Apr 2016 22:50:50 GMT

Yes the chart looks like what I wanted , but I have few questions here ,

1.What is the concatenation of date and time doing ? I mean how is it being calculated and plotting the dots.. I see a number but cannot understand how its helping to plot the chart

2.the enable scroll bar is disabled .. is that feature not allowed in these chart types? I want to see all dates with a scroll bar .. is that possible?

3.And also what does 2 represent , nothing seems to happen if I change it

Re: Chart Question

swuehl — Thu, 07 Apr 2016 23:07:55 GMT

1) You need at least one dimension in a scatter chart.

Since I haven't found a good candidate in your sample data table, I created a calculated dimension from these two fields.

As said, maybe not a the best or even a good choice, replace with something more appropriate (the field that should be used to group by your bubbles. Maybe something like IngestionID)

2) Not sure about that, I haven't encountered a need for that till now

3) 2 is an arbitrary number, you are right

Re: Chart Question

Anonymous — Thu, 07 Apr 2016 23:30:18 GMT

Thank you so much .. I was actually looking for something as below for the scatter chart