Discussion board where members can get started with Qlik Sense.
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.
=Week(Date#(Date,'DD MM YY')) as Week_No,
i dont want to display weeknumber but the sum of sales till the date is selected
can you post the sample data with expected output pls