Discussion board where members can get started with Qlik Sense.
I have id,value,fromdate and todate fields. I want to get all the dates between these two fields.
When i use while loop
Date( FromDate + IterNo() - 1 ) as DateKey
While FromDate + IterNo() - 1 <= ToDate;
The output is:
Id value datekey
1 1 2019/03/01
1 1 2019/03/02
1 1 2019/03/03
The issue is for Id=1 the sum(value) should be 1 but because of while loop now the value is 3.
$(varFrmDate) + Iterno()-1 As Num,
Date($(varFrmDate) + IterNo() - 1) as TempDate
AutoGenerate 1 While $(varFrmDate) + IterNo() -1 <= $(varToDate);
I would suggest have the date calender in another table, similar to mastr calender.
Try similar to below
load id, value from table_name;
load id, datekey // use your code here , dont use value here
both the table should be joined by id.
Can anyone help pls.
Maybe sum( firstsortedvalue(value,Date)) ??