Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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