Discussion board where members can get started with Qlik Sense.
I have a data set as like below:
But I need a new column as like below:
can anybody help in this!!!
Data:Load * Inline[Year, Sale2014, 100002015, 150002016, 200002017, 30000];
Left JoinLoad Year+1 as Year,alt(Sale,0) as PreviousYearResident Data;
View solution in original post
Hi YogananthaTry this expressionRangesum( below( Sum( Sales), -1 ) )Br.Teis