Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

New to Qlik Analytics

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

Who Me Too'd this solution

omkar_2611
Partner - Contributor II
Partner - Contributor II
‎2022-11-22 02:55 AM

Temp_Table:
LOAD * inline [
ID, Items, From, Till, Check
501, 8, 111, 120, 2
502, 10, 781, 792, 2
];

Table:
LOAD *,
From + IterNo() - 1 as Value
Resident Temp_Table
While Till >= From + IterNo() - 1;

Drop Table Temp_Table;

View solution in original post

1 user say ditto
939 Views
Who Me Too'd this solution