If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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.
LOAD * inline [COST, NAME, FINAL_DATE,GD56YTG, pippo, 31/07/2020,GD56YTG, teo,,FF56YTG, gino,];
COST, DATA, VALUE,GD56YTG,10/02/2020,70,GD56YTG,11/06/2021,30,GD56YTG,20/05/2021,40,FF56YTG,20/05/2021,40
@Carlaf_93 can you share the expected output ?
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