Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Cross-table excel double entry

hello, I'm new to qlikview, I need help with a double entry excel, I can not find the way to get the excel income. Thanks for the help.

1 Reply
prieper
Master II
Master II

You may filter these tables by using RECNO():

Table1: LOAD .... FROM .... WHERE RECNO() >= 3 AND RECNO() <= 5;

Table2: LAOD .... FROM .... WHERE RECNO() >= 9 AND RECNO() <=11;