topic Re: Week object in QlikView

Week object

nareshthavidishetty — Wed, 17 Feb 2016 08:25:15 GMT

Hi am having week object as below'

But i need to show week1,week2,week3,week4,week5 ,if i click on week1 it reflects the calender

Re: Week object

tamilarasu — Wed, 17 Feb 2016 08:27:50 GMT

Go to listbox property and type expression as

='Week' & YourFieldName

Re: Week object

MayilVahanan — Wed, 17 Feb 2016 08:28:46 GMT

Try like this

In Script,

'week' & Week(DateFieldName) as Week

Re: Week object

nareshthavidishetty — Wed, 17 Feb 2016 08:43:26 GMT

Thanks! The o/p is as below after using the logic suggested by you

But its not the requirement i have only five weeks as week1,week2,week3,week4,week5 suppose if the user make moth selection with in the month usere wants to know third week sales means week3 sales

Re: Week object

jagan — Wed, 17 Feb 2016 08:56:01 GMT

Hi,

Try like this

Data:

LOAD

Month(Date) AS Month,

'Week' & Ceil(Day(Date)/7) AS WeekInMonth

From DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Week object

MayilVahanan — Wed, 17 Feb 2016 08:56:17 GMT

Are you looking something like this

'Week' & Ceil(Day(DateID) /7) AS Week

Re: Week object

nareshthavidishetty — Fri, 11 Mar 2016 09:38:44 GMT

Hi Jagan,

After using the below logic,

'Week' & Ceil(Day(Date)/7) AS WeekInMonth

am getting result as

which is not correct if we check with January-16 calender ,week1 having only 1 & 2 but here it shows 1 to 7 .please help me to get this.

Thanks..