topic Re: How to draw a qlikview Scatter Chart in QlikView

How to draw a qlikview Scatter Chart

Wed, 25 Nov 2020 16:16:04 GMT

Dear Experts,

I have have a requirement where I am supposed to configure a scatter chart to show the number of employees arriving in a particular time interval.I have the data of employee ids and their corresponding entry time(in-time).I was able to create a datafield termed TimeBucket as given below .Now I need support to create a scatter chart to show the count of employees arriving at a particular TimeBucket.I tried creating with Emp-id as dimension,TimeBucket in x-axis,in-time in y-axis and Emp-id as bubble size expression but I am not getting the desired result.A sample of straight chart output is given below.In this example the number of employees arriving between 8am-9am is 1,9am-10am is 3,10am-11am is 2 and 11am-12pm is 1 which should be the size of bubble.Thank you for your time and consideration.

Emp-id	in-time	TimeBucket
1900	08:30:23	8 am - 9 am
1901	09:10:10	9 am - 10 am
2000	09:40:29	9 am - 10 am
1995	09:45:23	9 am - 10 am
2501	10:05:09	10 am - 11 am
1989	10:30:12	10 am - 11 am
1850	11:02:45	11 am - 12 pm

Regards

Rishi

Re: How to draw a qlikview Scatter Chart

swuehl — Mon, 30 May 2016 16:38:50 GMT

I think what you need is a bar chart and showing a histogram:

Use TimeBucket as dimension and

=Count(DISTINCT Emp-Id)

as expression.

If you really want to use a scatter chart, please elaborate which axis expressions you want to use, using TimeBucket and in-time doesn't make much sense to me.

Recipe for a Histogram

Re: How to draw a qlikview Scatter Chart

MarcoWedel — Mon, 30 May 2016 21:40:47 GMT

Hi,

as a scatter chart might not be appropriate to visualize In-time buckets and number of employees, maybe you could add an out-time bucket as second expression to define the bubble position. The number of employees might as well be colour coded instead of using bubble sizes:

Another solution could be a grid chart instead:

tabEmpTime:
LOAD *,
    Time(InTime+NORMINV(Rand(),'08:00','02:00')) as OutTime;
LOAD 999+RecNo() as EmpID,
    Time(NORMINV(Rand(),'08:00','02:00')) as InTime
AutoGenerate 1000;

hope this helps

regards

Marco

Re: How to draw a qlikview Scatter Chart

Tue, 31 May 2016 05:11:37 GMT

Dear Macro

Thank you for your quick response.I hope its better to use bar chart for better understanding as suggested.Thank you for making me understand as how to accomplish the same through these charts.

Re: How to draw a qlikview Scatter Chart

Tue, 31 May 2016 05:14:07 GMT

Dear Swuehi

I thought to use scatter chart but bar chart explains pretty well.Thank you for your consideration and helping me

Regards

Rishi