Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is there a way that I can get an expression that shows my days of the week as (for e.g) "13 - Wed" assuming that this is the Day/ Weekday combination of the 13th of Jan 2016 which is a Wednesday.
In short, I have loaded Day(date) and Weekday(date) into my data but I'm wondering if there is an expression that combines the two.
Thanks,
D
Try this may be:
=Date(Today(), 'DD - WWW')
Hi Sunny,
I tried that but all it does is give me todays date in a column with the day like 27-Wed.
What I need is to Load a column which loads the date and day based on the date column.
Thanks for your help anyway.
D
Well the above was to show how you can format date in that particular format. For changing your date to that format in the script, you can try the following:
Date(DateField, 'DD - WWW') as [Day-Week],
Here is a sample to look at:
Table:
LOAD Date,
Date(Date, 'DD - WWW') as [Day-Week];
LOAD Date(MakeDate(2014, 12, 31) + RecNo()) as Date
AutoGenerate 721;
Thanks Sunny,
Adding Date(DateField, 'DD - WWW') as Day-Week to the Load script worked perfectly.
Regards,
D
Awesome. I am glad you were able to figure it out.
Would you mind closing this thread by marking correct and any helpful answers? Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny