Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
luke1986
Contributor III
Contributor III

Load only every Nth Row

Hello Folks,

I am struggling with a dataset but couldnt find any easy/quick solution.

So basically my sample data looks like this:

RownoData
1basdf
2asdfg
3asdfgf
4adgfd
5adad
6adrete
7adads
8adsad
9adsad
....

After loading the first Row, I only want to load every third Row in Code

So the Output should look like this:

RownoData
1basdf
3asdfgf
6adrete
9adsad
...

Thanks!

2 Replies
kenphamvn
Creator III
Creator III

Hi

Try this

Load *

From Table

where rowno =1 or mod(rowno,3) =0

luke1986
Contributor III
Contributor III
Author

Thanks man, it worked! Didnt knew that function 🙂