Discussion Board for collaboration related to QlikView App Development.
I have no idea if this is possible, but i want to achieve this:
excel file shows:
I now i would like qlikview to automatically create this table below (in the script!) so I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.
You can see that for Name 'A' 5 records have been created with a Value range from 1 to 5 and three records with a range from 12 to 14.
When this table is created I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.
Is this possible?
Your help is very much appreciated.
Check this attach file and let me know.
View solution in original post
Try using Iterno() in load with a while clause .
Yes this works perfect.
I've already implemented this in my project.