topic Re: Loop script help in QlikView

Loop script help

Wed, 25 Nov 2020 16:16:04 GMT

I am quite new in development in QlikView scripting and I would like to ask for help.

My original data consist of 3 columns: Date, Part_old and Part_new. When there is just one change there is no problem for me to write script. Problem is when, like you see in example a part 'aaaa' is replaced by 'bbbb' on January 1st and afterwards the part 'bbbb' to 'eeee'. Below you can see the original data structure and the desired new layout.

I thought about do while statement, but I am not able to declare variable which will take the value from column C, check the whole column B to find whether there is more replacements of part and write it in a way I described above.

Thanks for help

Michal

Re: Loop script help

engishfaque — Fri, 08 Apr 2016 16:52:01 GMT

Dear Michal,

This is called slowly changing dimension. Please check listed below article,

Slowly Changing Dimensions

IntervalMatch and Slowly Changing Dimensions

Kind regards,

Ishfaque Ahmed

Re: Loop script help

Gysbert_Wassenaar — Fri, 15 Apr 2016 09:22:17 GMT

Why is bbbb the Partold_original of cccc?