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

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
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

1 Solution

Accepted Solutions
sunny_talwar

Try this:

LET vVAR = FieldValueCount('Field Y');

View solution in original post

1 Reply
sunny_talwar

Try this:

LET vVAR = FieldValueCount('Field Y');