Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Given the list box, call Day, I would like to group the days into weeks. Achieved this, I would like to represent the weeks on a graph. Each bar in the graph to represent the number of requests in a given week. Any suggestions?
I would like to get a similar result as I have done for months:
Thanks to all
Carlo
Did you try Week() function. Not sure if I am missing something.
Check out the attached.
Thanks
AJ
Thanks for the reply Ajay, but I am using the free version of qlikviewe and I can not open your transformation. Could you post the code?
Thanks
Carlo
Sure.
Table:
LOAD *,Week(DateField) as WeekField INLINE [
Request, DateField
A, 5/16/2014
A, 5/16/2014
B, 5/16/2014
B, 1/1/2014
C, 1/15/2014
C,5/1/2014
D,2/3/2014
D,4/13/2014
];
And in the front-end you can use WeekField as the Dimension and say Count(Distinct Request) as Expression.
Thanks
AJ
Hi Carlo, use WeekName or Week function as per your needs.
Thank you all for Support are able to obtain the desired result.
I used to like you suggested the function week and I got the following result:
I simply wrote the script:
Date#(Lower(Mid(@4,2,11)),'DD/MMM/YYYY') as DATA,
Week(Date#(Lower(Mid(@4,2,11)),'DD/MMM/YYYY')) as Settimane,
Thank you very much
Carlo