What function is recommended by QlikView to calculate the number of values in a field

[#1]

Hi,

Please anyone share the answer

[#2]

Count()

[maxgro]

or count(distinct field)

[alexandros17]

use fieldvaluecount(myfield) Look for this instruction in help

[ashfaq_haseeb]

If you want to avoid distinct

Try not to use count function on Key fields.

Regards

ASHFAQ