Discussion board where members can learn more about Qlik Sense App Development and Usage.
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.
Try this may be:
=Date(Today(), 'DD - WWW')
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.
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:
Date(Date, 'DD - WWW') as [Day-Week];
LOAD Date(MakeDate(2014, 12, 31) + RecNo()) as Date
Adding Date(DateField, 'DD - WWW') as Day-Week to the Load script worked perfectly.
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