topic Re: Binning Quantitative Data in QlikView

Binning Data

Mon, 06 Apr 2015 11:03:42 GMT

Hi,

I have done Pareto analysis and sorted dimension in descending order according to sales with salesman name as a dimension, but as we have several sales men, would like to bin them in group of 20 with total sales in decreasing order. Please help me to do same.

Best regards,

Navdeep

Re: Binning Quantitative Data

Mon, 06 Apr 2015 11:08:36 GMT

PFA the app "sorry for wrong heading", dimension contains names so not Quantitative

Re: Binning Quantitative Data

petter — Mon, 06 Apr 2015 11:09:17 GMT

You should look at the Class() function that could either be used in your Load Script or in your Chart to bin your quantitative data into bins of size 20.

You can use Class() directly in a calculated dimension.

Re: Binning Quantitative Data

Mon, 06 Apr 2015 11:11:57 GMT

Hi Petter,

Sorry for wrong heading,my data contains Names.

I tried class function but it's not working, I guess it takes Numerical input for binning.

Re: Binning Quantitative Data

petter — Mon, 06 Apr 2015 12:23:53 GMT

You will have to use the Rank() function to give them a numerical valid ranking number and then bin them according to that. The top 20, then the 21..40th ... and so forth by combining Class() and Rank() and possibly Aggr() too...

Re: Binning Data

Tue, 07 Apr 2015 10:54:30 GMT

=class(aggr(Rank(sum(Quantity)),ISPName),20) used this in dimension.