Discussion Board for collaboration related to Creating Analytics for QlikView.
I thought using GetSelectedCount(FieldName, True()) was supposed to return the total number of distinct values in a field?
It works for GetSelectedCount(FieldName) where the selected values are returned but I would like to get the total number of values in the field.
* INLINE [F1, F2, F301/01/2012, 01/01/2013, 101/01/2012, 02/01/2013, 201/01/2012, 03/01/2013, 302/01/2012, 01/02/2013, 402/01/2012, 02/02/2013, 502/01/2012, 03/02/2013, 6]
I'd expect GetSelectedCount(F1, True()) to return 2 at all times (as only 2 unique values) but this isn't happening.
Is the only way (?) to do the following instead?
Count (Distinct All F1)
Go to Solution.
You can use fieldvaluecount('F1') too. That's likely the best performing way to get that number.
Is there another easy one for All values i.e. F1 above would return 6.
count( all F1)
You can also calculate the value in script in a floating table.
Do you mean creating a table in the script that wouldn't be linked up to anythng else but would hold these values?