topic Re: Need Help..? in QlikView

Need Help..?

paulwalker — Wed, 26 Nov 2014 18:26:04 GMT

Hi Community,

i need some help..

i have created master calendar, but i need week wise data (W1, W2, W3, W4, W5 and W6 also)

how to calculate Week's........

based on selection date i want display last 6 weeks data..

like W1, w2, w3 w4, w5 and w6.......

i am using this 'W' & Ceil(Day(Date)/7) as Week

it will show W1 to W5 only but i want to W6 also...

Hope you Understand............

Re: Need Help..?

paulwalker — Wed, 26 Nov 2014 19:07:11 GMT

Hi All,

Suppose i have select one date (like 11/23/2014)

i want to show week wise data ( W1, W2, W3, W4, W5 and W6 )

Re: Need Help..?

ManuelRühl — Wed, 26 Nov 2014 19:40:06 GMT

There is a funktion called week().

It returns the week of a date.

Re: Need Help..?

paulwalker — Wed, 26 Nov 2014 20:00:29 GMT

Please can you explain bit more..

i want show like this....

Re: Need Help..?

paulwalker — Thu, 27 Nov 2014 02:30:06 GMT

is it possible.??

How to calculate 54 weeks.......

Re: Need Help..?

jagan — Thu, 27 Nov 2014 02:47:30 GMT

Hi,

Day() will return the number of day in the month, for example for Today(27-Nov) it will return 27, instead if you want to get the week of the year try like this

LOAD

Week(TempDate) AS Week

FROM DataSource;

LOAD

Ceil(DayNumberOfYear(TempDate)/7) AS Week

FROM DataSource;

Hope this helps you.

Regards,

Jagan.

Re: Need Help..?

paulwalker — Thu, 27 Nov 2014 03:05:55 GMT

Hi Jagan,

in my chart i want to show only W1, w2, w3, w4, w5 and w6..

based on current selection..

LOAD *,

if(Date<=7,'W1',

if(Date>7 and Date<=14,'W2',

if(Date>14 and Date<=21,'W3',

if(Date>21 and Date<=28,'W4',

if(Date>28 and Date<=35,'W5',

if(Date>35 and Date<=42,'W6')))))) as Week;

is it possible like this.........

Re: Need Help..?

jagan — Thu, 27 Nov 2014 03:17:14 GMT

Hi,

Then try like this

LOAD

Ceil(DayNumberOfYear(TempDate)/7) AS Week

FROM DataSource

Where DayNumberOfYear(TempDate) <= 42;

Hope this helps you.

Regards,

Jagan.

Re: Need Help..?

jyothish8807 — Thu, 27 Nov 2014 03:28:58 GMT

Hi Paul,

The issue over here is, maximum possible weeks in a month is '5', so in your application when a new month starts its taking its as week1 again.

Regards

Re: Need Help..?

paulwalker — Thu, 27 Nov 2014 03:32:50 GMT

yes, based on selection..

i want to show past 6 week data .........

see this link i have posted clearly...........

Past 7 weeks data display