If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have a table with three columns.
There is a fixed value in the first column.In the second column the minimum value of a number range.In the third column the maximum value of the number range.
I want to write a subscript with Qlik that writes all numbers of the number range with the value from the first column.
It should look like that:
Can any of you please help me?
This is easiest to achieve using Load... while:
Load Value, Min + IterNo()-1 as NumberWhile Min+IterNo()-1<=Max;Load * INLINE [Value, Min, MaxA, 1, 100B, 101, 150C, 151, 200];
View solution in original post
Perfect and so easy!
Thank you!!!! 😄