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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
BMazurekDND
Contributor
Contributor

What does the qlik.app.field.getData's frequencyMode parameter mean?

I'm looking at the documentation for qlik.app.field.getData()

https://help.qlik.com/en-US/sense-developer/November2019/Subsystems/APIs/Content/Sense_ClientAPIs/Ca...

and see a frequencyMode parameter (absolute, percent, relative and no frequency). Can someone explain what these mean? I haven't found anything with web or community searches.

I see corresponding values in the NxFrequencyMode enum of the SDK: https://help.qlik.com/en-US/sense-developer/November2019/APIs/Net+SDK/html/T_Qlik_Engine_NxFrequency...

but no explanation there either.

The SDK page for ListObjectDef.FrequencyMode https://help.qlik.com/en-US/sense-developer/November2019/APIs/Net+SDK/html/P_Qlik_Engine_ListObjectD...

has this description: "The frequency mode is used to calculate the frequency of a value in a list object." but that still doesn't give me much insight into what it is or why I might choose one value over another.

Labels (1)
1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Frequency is the count of occurrences (# of rows) of a value on the field. So given a Field "Fruit" in a table with three rows of values:

Apple
Apple
Pear

The Absolute frequency would be:

Apple: 2
Pear: 1

The Percent frequency would be:

Apple: 67%
Pear : 33%

I don't know what the "Relative" option returns. If you try it, let me know what you find. 

-Rob