Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Aggregate values ​​in a list box

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?


imm.JPG.jpg


I would like to get a similar result as I have done for months:


ultimo.JPG.jpg

Thanks to all
Carlo

5 Replies
Not applicable
Author

Did you try Week() function. Not sure if I am missing something.

Check out the attached.

Thanks

AJ

Not applicable
Author

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

Not applicable
Author

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

Not applicable
Author

Hi Carlo, use WeekName or Week function as per your needs.

Not applicable
Author

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:

esitofinale.JPG.jpg


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