Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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!