topic Re: First Value in QlikView

First Value

Fri, 06 Jun 2014 09:37:54 GMT

Hi,

I have a week that is mapped to two periods.

For eg: 2014 W18 is mapped to both 2014 April and 2014 May.(5 days in April and 2 days in May)

But I would like to have2014 April to be mapped for 2014 W18.

Could anyone help me to get the logic.

Thanks &regards,

Vinitha

Anonymous — Fri, 06 Jun 2014 09:41:35 GMT

place me the sample application

Then we can understand easily..

CELAMBARASAN — Fri, 06 Jun 2014 09:45:27 GMT

How you are creating the week?

Post your script on creating this calendar and the sample app. we need to be little bit clear in understanding this

Anonymous — Fri, 06 Jun 2014 09:48:10 GMT

Hi,

I believe, you already have calendar table with weekno and dates and you are mapping weekno to your transaction table. Try using WeekStart function.

=MonthName(WeekStart(Date))

Thanks

hic — Fri, 06 Jun 2014 12:24:13 GMT

If your week is defined by Week(Date), then Month(Date) will always return 'May' for the last days of that week.

However, if you instead define Month as

Month(WeekStart(Date)) as Month

then it will work the way you want.

HIC