Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Week Calculation Issue.

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.

4 Replies
TigerisBack
Champion
Champion


use this in dimension

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

or in script and use field creted in dimension

hope this helps

Not applicable

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

TigerisBack
Champion
Champion

see the attched file

Not applicable

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