Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
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

3 Replies
oscar_ortiz
Partner
Partner

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!