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

Announcements
Congratulations to the new Qlik Luminary and Partner Ambassador class! Meet them here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

count distinct

Hi

I need to set a LET variable in my script (on the back front). This variable should count all distinct values in the Field Y.

How can I do it?

Thank you in advance,

Larisa

Labels (1)
1 Solution

Accepted Solutions
sunny_talwar
MVP
MVP

Try this:

LET vVAR = FieldValueCount('Field Y');

View solution in original post

1 Reply
sunny_talwar
MVP
MVP

Try this:

LET vVAR = FieldValueCount('Field Y');