Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Join “Do More With Qlik” with Mike Tarallo to get a first-hand look at the New Authoring Experience, June 29th: REGISTER HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
rahulsingh12
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
dsharmaqv
Creator III
Creator III

Try this

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

rahulsingh12
Contributor III
Contributor III
Author

Hi

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

dsharmaqv
Creator III
Creator III

can you post the sample data with expected output pls