Discussion Board for collaboration on QlikView Scripting.
I have a problem with the following situation. I got a data view called AGERANGES with the following structure and data:
AGEFROM AGETILL AGEGROUP
4 16 4-16
17 33 17-33
34 77 34-77
78 119 78-119
Next to this table I have a person table named PERSON with a field birthdate.
Now i have the following coding in my script:
LOAD AGEFROM+(iterNo()-1) as Age,
WHILE IterNo() <= (AGEFROM - AGETILL)
FROM AGERANGES ;
Age (today(), BIRTHDATE) as Age,
When my source is a Excel file with the script above and I looked in QW in the leeftijden table the result is as attached in attachment.
If the result is as I descibed in the attachment I can join it easily with the person table.
If I use the dataview AGERANGES the table is empty
Can anybody help me?
I would suggest using a mapping table instead, please have a look at this thread:
Ah sorry, missed your points, you don't see the data from your view, right?
Your user has all necessary rights in the DBMS?
It finaly works.
I do not exactly know what was causing troubles. It works without using a map, with the solution I mentioned in the original post.