Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks,
i got a question, my data do look like:
From | Until | Price |
01.03.2021 | 04.01.2022 | 150,00 € |
05.01.2022 | 07.03.2022 | 160,00 € |
my expected output is:
Data | Price trend |
01.03.2021 | 150,00 € |
04.01.2022 | 150,00 € |
05.01.2022 | 160,00 € |
07.03.2022 | 160,00 € |
my question is, how can i merge two data datacolumn like (from and until) into one datafield, to show the price trend?
Does anybody have any idea how to rectify this issue.
Thanks a lot
Bek
Hi, see the script:
Data:
LOAD * INLINE [
From, Until, Price
01.03.2021, 04.01.2022, 150,00 €
05.01.2022, 07.03.2022, 160,00 €
];
TempData:
NoConcatenate Load
From as Date,
Price
resident Data;
Concatenate(TempData)
Load
Until as Date,
Price
resident Data;
Drop table Data;
Btw: maybe IterNo would be a good suggestion to use for calculation between two date fields. (so you could select at a certain moment in time. https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/CounterFun...
@JHuis Thanks a lot for your help and your time, I know this procedure, but I thought there was another solution (e.g. with recno()).
Thanks anyway for your support