Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join us for a live Q&A! September 21, 10 AM ET - Onboarding Fast in Qlik Sense SaaS! REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator
Creator

costs

Good morning,

I'm trying to link a cost to a specific person. I've got a type of cost and a final date until when that cost is linked.

For example the date 10/02/2020 is < of 31/07/2020 then the 70 will be linked to pippo and so on....

How can i do it? If there isn't a date it means that it still works now.

TAB1:

LOAD * inline [
COST, NAME, FINAL_DATE,
GD56YTG, pippo, 31/07/2020,
GD56YTG, teo,,
FF56YTG, gino,];

TAB2:

COST,  DATA,  VALUE,
GD56YTG,10/02/2020,70,
GD56YTG,11/06/2021,30,
GD56YTG,20/05/2021,40,
FF56YTG,20/05/2021,40

2 Replies
Taoufiq_Zarra

@Carlaf_93  can you share the expected output ?

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Carlaf_93
Creator
Creator
Author

COST,  DATA,  VALUE, 
GD56YTG,10/02/2020,70,   --> pippo,
GD56YTG,11/06/2021,30,  -->  teo,
GD56YTG,20/05/2021,40,  -->  teo,
FF56YTG,20/05/2021,40,  -->    gino