Solved: consider only latest record in display - Qlik Community

Anonymous · ‎2015-08-24

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

kaushiknsolanki · ‎2015-08-24

Hi,

Please find the solution attached here with.

Hope this is what you required.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

vikasmahajan · ‎2015-08-24

Hii,

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

HTH

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

kaushiknsolanki · ‎2015-08-24

Hi,

Please find the solution attached here with.

Hope this is what you required.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!