merge two data column in one column - Qlik Community

beck_bakytbek · ‎2022-03-07

Hi Folks,

i got a question, my data do look like:

my expected output is:

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

JHuis · ‎2022-03-07

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...

beck_bakytbek · ‎2022-03-07

@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