If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I am new to Qlik Sense & I am trying to implement a logic into qlik editor but I am stuck at a point. How can I add multiple rows based on the calculation of values of 2 columns?
I have a following table:
I want to create a new column which adds the rows value between 'till' and 'from' columns.
e.g. (120+1) - 111 = 10,
10 values = 111,112,113,...,119,120
Temp_Table:LOAD * inline [ID, Items, From, Till, Check501, 8, 111, 120, 2502, 10, 781, 792, 2];
Table:LOAD *,From + IterNo() - 1 as ValueResident Temp_TableWhile Till >= From + IterNo() - 1;
Drop Table Temp_Table;
View solution in original post