topic Can Qlik do frequency distribution graphs in QlikView

Can Qlik do frequency distribution graphs

Fri, 12 Feb 2010 16:35:39 GMT

Ok. I'm new to Qlik, so perhaps this is really just a redirection to the proper section of the manual.

NOTE I'm running Personal Edition, trying to evaluate if Qlik is up to the task I plan to use it for in my product.

I have a data set of 1million rows of trouble ticket summary record, which I want to analyse and present in the form of a frequency distribution graph.

Each record contains a field: trouble-ticket-duration (hours). I want to present a FD/histogran showing the distribution of durations.

How do I do this with Qlik?

In addition, I also want to present the data, so I can easily show which % of the trouble tickest have a call duration less than 1 hour. Can I also do a probability distribution graph on the same data?

Thanks for your help

Jim

Can Qlik do frequency distribution graphs

johnw — Sat, 13 Feb 2010 01:10:38 GMT

Well, it's not your data, and not exactly what you're asking for, but here's a simple frequency distribution example. Do a reload for a new, random set of data.

Can Qlik do frequency distribution graphs

Sat, 13 Feb 2010 10:11:49 GMT

Here another example to show a statistical distribution based on random simulation.

Maybe something useful : generation of sample from Normal(0,1) law.