topic Re: loop in Qlik Sense in App Development

loop in Qlik Sense

Di_Ne_Sh — Wed, 12 Jul 2023 05:26:45 GMT

Hi,

I'm trying to run loop for every single record based on start month and end month in table. The data should be added in new line for every month.

Source Table:

I need to get something like

Or — Wed, 12 Jul 2023 11:19:29 GMT

Something along the lines of:

Load ID, StartMonth, EndMonth, StartMonth + IterNo() - 1 as Month, Amount

From YourTable

While StartMonth + IterNo() -1 <= EndMonth;

Di_Ne_Sh — Wed, 12 Jul 2023 13:33:23 GMT

Thanks for the answer. Have achieved this with Intervalmatch function