topic Re: QV doesn't display week in ISO format in QlikView

QV doesn't display week in ISO format

t_chetirbok — Mon, 18 Dec 2017 08:02:20 GMT

Hello,

As I know QV uses ISO format of weeks.

But now I have a problem that week(today()) returns 52, but it should be 51.

Of course I can add FirstWeekDay, BrokenWeeks, ReferenceDay. But that is not a solution.

Do you know why I have this strange behavior?

Thanks,

Tatiana

Re: QV doesn't display week in ISO format

upaliwije — Mon, 18 Dec 2017 09:10:49 GMT

Sorry I have no idea about this please

Re: QV doesn't display week in ISO format

t_chetirbok — Mon, 18 Dec 2017 09:15:02 GMT

hmm,

Did you post this reply only for getting one point?

Re: QV doesn't display week in ISO format

upaliwije — Mon, 18 Dec 2017 09:26:59 GMT

Please don't think that way. If I wanted to collect points as you suggested I could have collected a lot of points by now. In fact I replied because your post had a mail in my inbox

Re: QV doesn't display week in ISO format

tamilarasu — Mon, 18 Dec 2017 09:49:03 GMT

Hi Tatsiana,

I am using QV 12.10 (tested in 12.10 SR7 as well) and the result is 51.

Re: QV doesn't display week in ISO format

t_chetirbok — Mon, 18 Dec 2017 09:54:44 GMT

yeah, I am using the same version.

and my system time is correct

but in QV 52

Re: QV doesn't display week in ISO format

tamilarasu — Mon, 18 Dec 2017 10:09:43 GMT

That's strange. I'm not sure about this behavior and I never faced this issue.

marcus_sommer‌ Hope you might have some answer for this behavior.

Re: QV doesn't display week in ISO format

Anil_Babu_Samineni — Mon, 18 Dec 2017 10:19:03 GMT

I think, you will getting wrong even if you use WeekName(Today())

Re: QV doesn't display week in ISO format

marcus_sommer — Mon, 18 Dec 2017 10:24:54 GMT

I assume it's a bug like mentioned here - please report it to Qlik that it could be fixed within one of the next releases. And for now as workaround you could try something like: subfield(weekname(today()), '/', 2):

- Marcus

Re: QV doesn't display week in ISO format

tamilarasu — Mon, 18 Dec 2017 10:28:50 GMT

Yes. Weekname function is returning wrong result for me (however week function returns the correct week number).

Re: QV doesn't display week in ISO format

marcus_sommer — Mon, 18 Dec 2017 10:42:55 GMT

That's bad ... I'm just on QV 11 and there it worked like it should. What will be returned by weekstart(today()) ? For me it's a bug but maybe there is some quick workaround to correct the wrong result and therefore my suggestion with weekname().

If it's a critical calculation and a urge solution is needed I would probably use a (include)-variable with a manual correction so that it would be easy to change again if there is a bug-fix available.

- Marcus

Re: QV doesn't display week in ISO format

t_chetirbok — Mon, 18 Dec 2017 13:39:00 GMT

Actually, I have a little bit different situation ) . The WeekName is correct here

Re: QV doesn't display week in ISO format

t_chetirbok — Tue, 19 Dec 2017 08:41:46 GMT

The result of Week() function is affected by 3 environment variables: FirstWeekDay, BrokenWeeks and ReferenceDay, which are set in the beginning of a reload script.

In QV12 by default we have those variables in the beginning of a reload script.

In QV11 we don't have it.

So, make sure that you set FirstWeekDay = 0, BrokenWeeks = 0 and ReferenceDay = 4, to have ISO format

Re: QV doesn't display week in ISO format

devarasu07 — Mon, 08 Jan 2018 05:47:22 GMT

Hi,

tried similar method but it's not working for 2018 Week 1. can you check below thread and advise me. Thanks

ISO Calendar issue