Week Calculation Issue.

[#1]

Hi All,

I want to calculate the week calculation month wise.And I want to show in a graph as follows-

April 2013 (1-7 ),April 2013 (8-14),April 2013 (15-21) and so on.

PFA of the Qlikview Application in which i am getting the correct result except Dec 2013.

Please check and reply ASAP.

Thank You.

[SunilChauhan]

use this in dimension

Monthname(Date)&'('&Day(weekStart(Date))&Day(weekend(Date))&')'

or in script and use field creted in dimension

hope this helps

[#3]

IF i use the above expression , I am getting but the problem is when we are showing the last week it display as Jan 2013 (28-3) Here 3 represents the date of February.

So I want for last week as Jan 2013 (28-31) .

[SunilChauhan]

see the attched file

[#5]

Piyushkumar,

I tryed to look for you application, but dont know why you have strange deceber results.

Abyway, i can not find any impact of user behaviour in UI on your dimension. If i'am right, your dimension is in fact static ...If it is static - you may and even (for performance reasons) should build it during reload.

regards

Darek