topic Re: Week Calculation Issue. in QlikView

Week Calculation Issue.

Wed, 23 Apr 2014 05:23:22 GMT

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.

Re: Week Calculation Issue.

SunilChauhan — Wed, 23 Apr 2014 06:56:19 GMT

use this in dimension

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

or in script and use field creted in dimension

hope this helps

Re: Week Calculation Issue.

Wed, 23 Apr 2014 07:03:56 GMT

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) .

Re: Re: Week Calculation Issue.

SunilChauhan — Wed, 23 Apr 2014 07:33:07 GMT

see the attched file

Re: Week Calculation Issue.

Wed, 23 Apr 2014 09:26:45 GMT

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