maybe not quite what you were looking for, but maybe a start:
FOR Each vtable in 5,6 tabPrenoms: LOAD RowNo() as ID, Name as PRN, AutoNumber(Name) as %PRN FROM [http://www.behindthename.com/top/list.php?region=france&year=2010&sort=&display=max] (html, unicode, embedded labels, table is @$(vtable), filters(Remove(Row, Pos(Top, 1)))) While IterNo()<=Times; NEXT vtable tabSubPrenoms: LOAD Distinct %PRN, Left(PRN,IterNo()) as SPRN, IterNo() as NBCAR Resident tabPrenoms While IterNo()<=Len(PRN);
Can you describe a bit more how the chart should look like?
Thank you for your answers.
I've been able to draw my chart using different loads in the script.
But what I'd like to do is to use dynamically my names to show the impact of entering 1, 2 or more characters to do a search in the database.
See the .qvd attached. There's a part using the script, and a dynamic part.
Thanks for your attention. !
TEST identito.qvw 172.0 K