topic Re: DATE/WEEK extraction from a column in format yy-mm-dd in App Development

DATE/WEEK extraction from a column in format yy-mm-dd

Uma7 — Fri, 15 Nov 2024 21:44:29 GMT

Hi,

i have a column creation date in format yymmdd from which i need to extract date and weekly data to make graphs.

how can this be done?

can anyone help me?

Thanks in advance!

Re: DATE/WEEK extraction from a column in format yy-mm-dd

tresB — Fri, 02 Jun 2023 05:51:24 GMT

Try like:

Date(Date#([Creation Date], 'yymmdd')) as Date,

Week(Date#([Creation Date], 'yymmdd')) as Week

Re: DATE/WEEK extraction from a column in format yy-mm-dd

Uma7 — Fri, 02 Jun 2023 06:01:32 GMT

Its not working
btw- my creation date column is of string type

Re: DATE/WEEK extraction from a column in format yy-mm-dd

tresB — Fri, 02 Jun 2023 06:20:46 GMT

Date#() parses string to date value. Then may be you should try like:

Date#([Creation Date], 'YYMMDD')

Re: DATE/WEEK extraction from a column in format yy-mm-dd

Uma7 — Fri, 02 Jun 2023 06:33:54 GMT

when i try the expression is ok but no data for date is displayed

Re: DATE/WEEK extraction from a column in format yy-mm-dd

tresB — Fri, 02 Jun 2023 06:49:57 GMT

That could potentially mean that your date values are not really in YYMMDD format. Try reloading the field directly in qlik, and see how exactly your data is read by qlik, and then use parsing format accordingly. Please note, additional spaces could also create problem.

Re: DATE/WEEK extraction from a column in format yy-mm-dd

srchagas — Fri, 02 Jun 2023 09:36:08 GMT

Try to Use:

On load script:

Date(Date#([Creation Date],'YYYYMMDD'),'YYMMDD') as [Creation Date]