Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

bouderbc
New Contributor III

How to count fields in a column ?

Hi experts,

How to count fields in a column ?

i 'm using count ([Alpha ]) or text count ([Alpha ]) but the result is different from excel ?

Any solutions please ?

Regards

Ali

2 Replies
krishnacbe
Valued Contributor III

Re: How to count fields in a column ?

Can you share the Sample data to debug the issue

marcus_malinow
Valued Contributor II

Re: How to count fields in a column ?

If you're looking to count distinct values try:

COUNT(DISTINCT [Alpha ])

otherwise for all values

COUNT([Alpha ])

Community Browser