This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
For Example I have a table lets say Data
In Data table we have 5 fields Lets say
A, B , C , D , E
Now Column E contains values in some rows that comes from column A
or we can say that Column E parent column is A.
So, how can we link or make a relationship in both the columns.
You can achieve this by using Self Join. Try the below script-
Temp:LOAD * INLINE [Employee_ID, Name, Gender, Manager_ID1, Cheri, Agender, 22, Golda, Bigender, 33, Hermina, Female, 64, Leoine, Genderfluid, 85, Marcelle, Genderqueer, 96, Marsiella, Male, 107, Michelina, Non-binary, 18, Rhianon, Polygender, 119, Ric, Male, 1210, Vicki, Bigender, 13];
Left Join(Temp)LoadEmployee_ID as Manager_ID,Name as Manager_Nameresident Temp;
Hope this helps.
We have been using this for several weeks now and it seems to be going nicely.