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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Ray0801
Creator
Creator

In file with 100 records, display last 5 records and then display the rest of the records .

I tried using tSampleRow but couldn't get the right solution.

Labels (2)
1 Solution

Accepted Solutions
Martintin
Contributor III
Contributor III

0683p000009M8jG.png

I don't know if this is what you'r looking for but it's working.

0683p000009M8jL.png

If the number of rows is fixed, you can do like that by playing with the main order and select wich tsample you wanna do first.

 

Hope it helps

 

View solution in original post

5 Replies
TRF
Champion II
Champion II

Give more details
Ray0801
Creator
Creator
Author

I have a file that has employee records
I have emp_id from 1-100 in order

I want to display the details of emp_id 95..100 and then the records of 1..94 in a tLogRow component using a tSampleRow preferably
TRF
Champion II
Champion II

Could you share your component settings, expected and obtained result?
Martintin
Contributor III
Contributor III

0683p000009M8jG.png

I don't know if this is what you'r looking for but it's working.

0683p000009M8jL.png

If the number of rows is fixed, you can do like that by playing with the main order and select wich tsample you wanna do first.

 

Hope it helps

 

TRF
Champion II
Champion II

You can also do it within a simple tMap:

0683p000009M8jQ.png

This is the complete job:

0683p000009M8jV.png