Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Qlikview for Developers - Use Case Chapter 12

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

5 Replies
passionate
Specialist
Specialist

if you don't have end date column then

what is logic for deriving end date?

shiveshsingh
Master
Master

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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

dripet
Contributor
Contributor

Hi,

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

Thanks