topic Show the selected week in the Label. in QlikView

Show the selected week in the Label.

Tue, 06 Mar 2012 10:16:42 GMT

Hi! is there a way to show the selected week in the Label field? (in a column)

//BR
Patrik

Edit:

Hi! thoose work but i was a little unclear in the first post sorry.

The thing is that I've six column displaying:

If i choose an interval where first week is week six and last week is week twelve

1st column: first week in the selection

2nd column: second week in the selection

3rd column: third week in the selection

etc etc

I would like the 1st column showing the first week name in the selection and the second week showing the second weeks name, etc

is it possible to do?

//BR
Patrik

Show the selected week in the Label.

jagan — Tue, 06 Mar 2012 10:19:01 GMT

Hi,

Use this expression in Label

=Only(Week)

Regards,

Jagan.

Re: Show the selected week in the Label.

CELAMBARASAN — Tue, 06 Mar 2012 10:19:16 GMT

Hi,

use Label as =GetFieldSelections(WeekFieldName,',') shows if selected many separated with comma.

Or you can try with this

=if(GetSelectedCount(WeekFieldName)>0,GetFieldSelections(WeekFieldName,','),'Week')

Hope it helps

Celambarasan

Re: Show the selected week in the Label.

Anonymous — Tue, 06 Mar 2012 10:27:06 GMT

Hope this attached file expression (textbox) will help you to show the selected date week name in the column or lable

Regards

Ashok

Show the selected week in the Label.

Tue, 06 Mar 2012 10:28:59 GMT

Hi! thoose work but i was a little unclear in the first post sorry.

The thing is that I've six column displaying:

If i choose an interval where first week is week six and last week is week twelve

1st column: first week in the selection

2nd column: second week in the selection

3rd column: third week in the selection

etc etc

I would like the 1st column showing the first week name in the selection and the second week showing the second weeks name, etc

is it possible to do?

//BR
Patrik

Show the selected week in the Label.

CELAMBARASAN — Tue, 06 Mar 2012 10:33:34 GMT

Hi,

Then try by incrementing

Min(Week),Min(Week)+1,Min(Week)+2..Min(Week)+6

Celambarasan

Show the selected week in the Label.

jagan — Tue, 06 Mar 2012 10:36:48 GMT

Hi,

Use this expressions

1st Week = Min(Week)

2nd Week = Min(Week) + 1

3rd Week = Min(Week) + 2

4th Week = Min(Week) + 3

5th Week = Min(Week) + 4

6th Week = Min(Week) + 5

Regards,

Jagan.