Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm looking at the documentation for qlik.app.field.getData()
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.
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