topic Re: Dual Date in QlikView

Dual Date

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

Hi All,

I am not able to complete this script , can you please help in resolving the below script line ?

Dual(Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY'))as Start_End_Date,

Thanks In Advance

Vegar — Fri, 27 Mar 2020 18:02:09 GMT

What's the issue with your script line. It looks ok to me.

Please explain your issue in more detail.

smilingjohn — Fri, 27 Mar 2020 19:03:54 GMT

Hi Vegar,

This is not generating me the weekend and weekstart date . I want something like below

1Mar20 - 7Mar20

8Mar20 - 14Mar20

15Mar20 - 21Mar20 and so on which I am not getting , The outpu is coming as blank

Thanks

Vegar — Sat, 28 Mar 2020 11:20:00 GMT

Try this.

Date( WeekStart( Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') & ' - ' & Date(WeekEnd(Date#(TempDate,'MM-DD-YYYY')),'DDMMMYY') as start_End_Date