Set analysis

[VishalSingh18]

hello all,

I am new to qlikview, and in my current app, i have date field with dates and value assigned as revenue to each field

what i want to achieve in graph is I have week no. as dimension

and in expression i want to sum all the value that falls under that week no. and show it across all available week

Thanks and Regards 

Vishal Singh

[sumanta1234 · Accepted solution]

Hi,

You need to get week no from date field by using the following function:

WEEK(Date) as Week No.