topic Re: Label for week in QlikView

Label for week

Anonymous — Fri, 23 Nov 2012 16:20:00 GMT

Hi guys,

How can I change Number of week for label of this week.

For example:

2012/35 to 21 Oct 2012 - 27 Oct 2012.

Tahnks,

Re: Label for week

swuehl — Fri, 23 Nov 2012 16:24:53 GMT

If you have used weekname() function to create your week numbers, you've got a dual with a numeric value representing start of that week. You can then try:

=Date(WeekNrField, 'DD MMM YYYY') & ' - ' & Date(weekend(WeekNrField), 'DD MMM YYYY')

Regards,

Stefan

Re: Label for week

Clever_Anjos — Fri, 23 Nov 2012 16:25:41 GMT

=WeekStart(Today()) &'-'& date(WeekStart(Today()) +7)

Re: Label for week

Anonymous — Fri, 23 Nov 2012 16:26:38 GMT

I got like it

WeekStart(date(submitDateTime))& '-' &WeekEnd(date(submitDateTime)) as AAA

Re: Label for week

Anonymous — Fri, 23 Nov 2012 16:34:51 GMT

I need to use this variable in charts.

I can't sort it.

Do you have any ideas?

Re: Label for week

Anonymous — Fri, 23 Nov 2012 16:37:10 GMT

I think I got it.

Sort by load order

Re: Label for week

Clever_Anjos — Fri, 23 Nov 2012 16:39:39 GMT

Use "dual" function

dual(WeekStart(date(submitDateTime))& '-' &WeekEnd(date(submitDateTime),WeekStart(date(submitDateTime))) as AAA

Re: Label for week

Anonymous — Wed, 12 Dec 2012 18:42:44 GMT

Hello,

could you help me to create expression with dual?

Thanks,

Re: Label for week

Clever_Anjos — Wed, 12 Dec 2012 19:32:27 GMT

Into your script maybe you are loading something like this:

LOAD

submitDateTime,

anotherfield,

anotherfiel2

from yourtable.qvd(qvd);

Use a command like this

LOAD

submitDateTime,

dual(

WeekStart(submitDateTime)& '-' &WeekEnd(submitDateTime),

WeekStart(submitDateTime)

) as my_new_field,

anotherfield,

anotherfiel2

from yourtable.qvd(qvd);

Re: Label for week

Anonymous — Wed, 12 Dec 2012 19:36:09 GMT

Thank you,

I got it.

I put ) not in right place.

Re: Label for week

Anonymous — Wed, 12 Dec 2012 19:37:10 GMT

I can't mark like Helpful Answer

Re: Label for week

Clever_Anjos — Wed, 12 Dec 2012 19:45:45 GMT

Maybe is because you already marked your answer as correct.

Don´t worry.

Re: Label for week

Anonymous — Wed, 12 Dec 2012 19:46:25 GMT

I think so.

Please do not upset.

Re: Label for week

Clever_Anjos — Wed, 12 Dec 2012 20:11:36 GMT

I´ll never be upset for such thing