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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Looping through the alphabet

Hi All,

I want to create a qvd for each letter in the alphabet and would like to use the loop function to do so.  However, when I attempt to use the following:

For vLetter = 'a' to 'z'

.

.

.

Next

I receive an error message.  The error occurs even if I remove the single quotes.  Any help you can provide will be greatly appretiated.

Thanks,
Carlos

1 Solution

Accepted Solutions
maxgro
MVP
MVP

for v=ord('a') to ord('z')

     let q=chr($(v));

     trace $(q);

next;

View solution in original post

4 Replies
oscar_ortiz
Partner - Specialist
Partner - Specialist

I think what you want to do is to use a numeric representation for your "a" to "z" such as 1 to 26.

Good luck

Oscar

maxgro
MVP
MVP

for v=ord('a') to ord('z')

     let q=chr($(v));

     trace $(q);

next;

Not applicable
Author

Slick!  Thanks!

shane_spencer
Specialist
Specialist

Awesome!