Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

consider only latest record in display

hi Guru's,

i have Fields like below

worker, Start date, End Date, Bill Rate,I nvioice submitted date

Issue:

one worker start date -3/2/2014    end date -2/2/2015

again next day he started working  start date 2/3/2015 end date 8/30/2015

so he has 2 records

now i want to show only 2/3/2015 end date 8/30/2015 record in dashboard

Please find the sample excel and dashboard

need to show latest start date and end date ,means single entry for worker

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Please find the solution attached here with.

Hope this is what you required.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post

2 Replies
Highlighted
Champion
Champion

Hii,

I think you can use Interval Match for the same please refer the link https://community.qlik.com/docs/DOC-3557

HTH

Vikas

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Please find the solution attached here with.

Hope this is what you required.

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".

View solution in original post