Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Weekly Data Display

Hi I have a condition where I get daily sales data.

if I select 7 it is my Week1 and if I select 9 it is my week2.

I want to show a weekly sum of sales in the bar chart.

But the only catch is if I select 9 i should get data as for week1(1-7) and week2(8-9)

similarly if i select 28 i should get week1(1-7),week2(8-14),week3(15-21),week4(22-28) clubbed.

Regards,

3 Replies
Highlighted
Creator III
Creator III

Try this

=Week(Date#(Date,'DD MM YY')) as Week_No,

Highlighted
Contributor III
Contributor III

Hi

i dont want to display weeknumber but the sum of sales till the date is selected

Highlighted
Creator III
Creator III

can you post the sample data with expected output pls