topic Re: Trim WeekDay function to show First letter in QlikView

Trim WeekDay function to show First letter

helen_pip — Fri, 26 Aug 2016 10:19:21 GMT

Dear Qlikview user

I am using the WeekDay function and as expected it returns values from Mon, Tue, Wed, Thur, Fri, Sat, Sun

I would like to trim down the WeekDay function so it just returns the first letter of each day I.e. M, T, W, T, F, S, S

Does anyone know how this can be achieved?

Kind Regards

Helen

sunny_talwar — Fri, 26 Aug 2016 10:21:30 GMT

May be like this:

Left(WeekDay(Date), 1) as [1stLetterWeekDay]

Dual(Left(WeekDay(Date), 1), Num(WeekDay(Date))) as [1stLetterWeekDay]

jpenuliar — Fri, 26 Aug 2016 10:25:31 GMT

Try modifying the MAIN script tab

SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

to below::

SET DayNames='M;T;W;T;F;S;S';

helen_pip — Fri, 26 Aug 2016 10:26:16 GMT

Hello Sunny

Thank you for your response

I have tried your techniques and unfortunately they are grouping the letters which are the same together I.e. Tue and Thu and both come under T now

Is there any way to stop the aggregation?

Kind Regards

Helen

avinashelite — Fri, 26 Aug 2016 10:29:26 GMT

Its the Qlikview nature to group the similar data if you have T and T how you will different it as Tue and Thu (don't consider the week order) .

sunny_talwar — Fri, 26 Aug 2016 10:29:46 GMT

Even the second method?

Dual(Left(WeekDay(Date), 1), Num(WeekDay(Date))) as [1stLetterWeekDay]

helen_pip — Fri, 26 Aug 2016 10:33:17 GMT

Your right Sunny

My mistake! The second option does work

Thank you so much!

Thanks

Helen

sunny_talwar — Fri, 26 Aug 2016 10:34:52 GMT

Although, I think you should also look into jpenuliar‌'s solution. I think its sleeker than what I provided