Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
use this in dimension
Monthname(Date)&'('&Day(weekStart(Date))&Day(weekend(Date))&')'
or in script and use field creted in dimension
hope this helps
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) .
see the attched file
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