Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
SunilChauhan
Champion II
Champion II

frequency calculation

hello,

i want to calculate frequency of item in column.

ex ample:

Load * inline [

1

2

1

2

3

1

2

3

];

then frequencies are 1---3

2----3

3----2

i dont wa

Sunil Chauhan
Labels (1)
2 Replies
Not applicable

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

matt_crowther
Specialist
Specialist

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