Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Jbekhazi
Contributor II
Contributor II

Transforming excel report into Qlik Table

In the attached excel example excel report I have the source that I need to input into qlik and the desired target table in the next sheet. 

Does anyone have any Idea how i can be done? I have come close but still have the Gate that I am unable to have them be repeated in every row.

1 Solution

Accepted Solutions
miskinmaz
Creator III
Creator III

first in script you have to load the table with "order by" clause and then use the peek function.

https://community.qlik.com/t5/QlikView-Documents/Using-Peek-and-Previous-Functions-Recursively-to-He...

see if the links help u

View solution in original post

1 Reply
miskinmaz
Creator III
Creator III

first in script you have to load the table with "order by" clause and then use the peek function.

https://community.qlik.com/t5/QlikView-Documents/Using-Peek-and-Previous-Functions-Recursively-to-He...

see if the links help u

View solution in original post