Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
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
Author

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
Author

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