Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
IMPORTANT: Upcoming LEF Database Maintenance, Oct. 3rd - SEE DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Set analysis

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Hi,

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

WEEK(Date) as Week No.

View solution in original post

1 Reply
Highlighted
Partner
Partner

Hi,

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

WEEK(Date) as Week No.

View solution in original post