topic Re: Format week in QlikView

Format week

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

Hi All ,

Please find the attachment of the QVW file ,

I want to show the weekeknd format like DD-MMM-YY ( 28-Jul-20) I tried conevrting it in the calendare in load script but still this doesnot change . Please suggest me .

Re: Format week

zhadrakas — Tue, 28 Jul 2020 10:44:56 GMT

try to change the default variables or comment them out

SET TimeFormat='h:mm:ss TT'; SET DateFormat='M/D/YYYY'; SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

regards

Re: Format week

Taoufiq_Zarra — Tue, 28 Jul 2020 10:46:50 GMT

if I understood correctly

Date(Weekend,'DD-MMM-YY')

attached qlik file

output :

Re: Format week

smilingjohn — Tue, 28 Jul 2020 11:44:11 GMT

You have changed the format of weekend within the listbix edit mode .

But i want the same format in the Load script . WHich I am strugling to do it

Re: Format week

Kushal_Chawda — Tue, 28 Jul 2020 21:36:40 GMT

try change below script.

Test:
LOAD
Date(Date#(Created),'DD-MMM-YYYY') as Created,
//Date(Created,'MM/DD/YYYY') as Date1,
Date(Date#(Created),'DD-MMM-YYYY') as Date

FROM
[C:\STestWeekend]
(qvd);

You can now simple change the format using Date function on Calendar