Re: Qlikview for Developers - Use Case Chapter 12 - Qlik Community

Anonymous · ‎2018-04-21

I want to get the End Date value from a qvd. But the End date column is not present in the QVD. But Start Date value is available. I know, I can get the End Date value by using the Peek function from the Start Date column. But it is not working as I expected. Can anyone please guide me?

The Start date value is in the format 'yyyy-mm-dd'.

Note: I tried to get the end date value by converting the start date value to number and subtract that value by -1 using peek function. And then convert it again to Date value by using the Date function with the format of 'yyyy-mm-dd'. Still no use...

passionate · ‎2018-04-21

if you don't have end date column then

what is logic for deriving end date?

shiveshsingh · ‎2018-04-21

Can you share your app here? What is the logic of end date?

Anonymous · ‎2018-04-22

Okay.. Here I'm using Intervalmatch function between the fact table(flight data) and Career Decode (dimension table)... Already I have End date in the (Career Decode) QVD... But I don't want to use that in the script instead of that i want to achieve that using the Peek function with Start date as my parameter. I have attached the qvd here....

This is my career decode script (current script)

[Carrier Decode]:

IntervalMatch (Date, [%Unique Carrier Entity Code])

LOAD

[Start Date],

If(Len([End Date]) < 1, Today(1), [End Date]) as [End Date],

[Unique Carrier Entity] as [%Unique Carrier Entity Code]

FROM

[..\3.QVD\Source\Carrier Decode.qvd]

(qvd);

Anonymous · ‎2018-04-22