topic frequency calculation in QlikView

frequency calculation

SunilChauhan — Thu, 27 Jan 2011 15:59:01 GMT

hello,

i want to calculate frequency of item in column.

ex ample:

Load * inline [

];

then frequencies are 1---3

2----3

3----2

i dont wa

frequency calculation

Thu, 27 Jan 2011 16:10:30 GMT

Hi sunil,

After loading if u create a listbox and in Properties-> General there is a box with frequency. If u click that it will show as u will. Hope this helps.

Sravan

frequency calculation

matt_crowther — Thu, 27 Jan 2011 16:17:15 GMT

Alternatively; create a Straight Table chart with your column as the Dimension and =count(YourDimension) as the expression.

That should do it.

Hope that helps,

Matt - Visual Analytics Ltd