topic Re: Qlikview for Developers - Use Case Chapter 12 in QlikView

Qlikview for Developers - Use Case Chapter 12

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Qlikview for Developers - Use Case Chapter 12

passionate — Sat, 21 Apr 2018 11:34:23 GMT

if you don't have end date column then

what is logic for deriving end date?

Re: Qlikview for Developers - Use Case Chapter 12

shiveshsingh — Sat, 21 Apr 2018 12:33:14 GMT

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

Re: Qlikview for Developers - Use Case Chapter 12

Anonymous — Sun, 22 Apr 2018 04:46:06 GMT

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);

Re: Qlikview for Developers - Use Case Chapter 12

Anonymous — Sun, 22 Apr 2018 04:46:18 GMT

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);

Re: Qlikview for Developers - Use Case Chapter 12

dripet — Thu, 26 Mar 2020 08:59:34 GMT

Hi,

Did you solve this case? can you share the solution?

Thanks