topic Re: Looping through the alphabet in QlikView

Looping through the alphabet

Mon, 01 Dec 2014 20:51:22 GMT

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'

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

Re: Looping through the alphabet

oscar_ortiz — Mon, 01 Dec 2014 20:59:36 GMT

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

Re: Looping through the alphabet

maxgro — Mon, 01 Dec 2014 21:02:02 GMT

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

let q=chr($(v));

trace $(q);

next;

Re: Looping through the alphabet

Mon, 01 Dec 2014 21:18:36 GMT

Slick! Thanks!

Re: Looping through the alphabet

shane_spencer — Mon, 25 Mar 2024 11:23:50 GMT

Awesome!