topic Re: Formatting date in QlikView

Formatting date

Anonymous — Thu, 15 Mar 2018 06:01:13 GMT

Any idea to make it to display as in red text? I'm using system default autoCalendar.YearMonth.

Re: Formatting date

Chanty4u — Thu, 15 Mar 2018 17:13:10 GMT

No i think

Re: Formatting date

PrashantSangle — Thu, 15 Mar 2018 17:36:06 GMT

Date(DateFieldName,'MMM-YYYY')

or monthName(DateFieldName

Regards

Re: Formatting date

Anonymous — Fri, 16 Mar 2018 01:17:11 GMT

I've done it with

=Date(Monthname([Goods Receipt Date]),'MMM-YY')

Re: Formatting date

Anonymous — Fri, 16 Mar 2018 01:19:39 GMT

Done thanks for the effort

Re: Formatting date

Anonymous — Fri, 16 Mar 2018 01:19:58 GMT

thanks for the effort

Re: Formatting date

Chanty4u — Fri, 16 Mar 2018 06:55:34 GMT

it will change entire datefield right? he need only 3 values ? correct me if i m wrong

Re: Formatting date

Anonymous — Fri, 16 Mar 2018 06:57:53 GMT

the 3 vales only example, i need entire datefield.

Re: Formatting date

tresB — Fri, 16 Mar 2018 07:08:21 GMT

Even if that is the case, one could use conditional expression like:

If(Date=..., Date(Date, <format1>), Date(Date, <format2>) )

Re: Formatting date

Chanty4u — Fri, 16 Mar 2018 07:22:14 GMT

Actually i thought two times he want to show for that particular red color months so i said no

If(Date=..., Date(Date, <format1>), Date(Date, <format2>) ) this will work but in each and every place the same way it will show right ?.

Re: Formatting date

tresB — Fri, 16 Mar 2018 07:33:07 GMT

I guess OP has got the answer in Prashant's reply and he wanted the format for all dates. However, to clarify your query, if you use calculated dimension, it would only show the effect where you use it.

Re: Formatting date

Chanty4u — Fri, 16 Mar 2018 07:34:28 GMT

thanks tresesco‌

Re: Formatting date

PrashantSangle — Sat, 17 Mar 2018 00:53:38 GMT

Close the thread by selecting correcting answer.

Re: Formatting date

simran04 — Sun, 18 Mar 2018 12:46:10 GMT

You can use "If" statement.

E.g., If(Date>'01/10/2018', green(), red()).

The above statement will result in green color if date is greater than the above mentioned date and red if it's below than that.