Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Loop in expression or text box

I am trying to create a generate a loop in the expression/text box on the based of selection in a table.

On the basis of selection I got the string in the table which is separated by comma (,) and I want to run the loop to find out how many strings I have after using

=SubStringCount(Priority_Combination, ',' )

and I want to store this in a variable so that I can run a loop.

and further want to store each value of string in a variable.

thanks

13 Replies
Not applicable
Author

As default I have assigned the variables on the load and assigned the value =0 now

I can count number of values by SubStringCount(Priority_Combination, ',' )

want to loop

for i=0 to SubStringCount(Priority_Combination, ',' )

and check if subfield(Priority_Combination, ',' ,i)= Vendor_Number then set the vVendorNo = 1

Hope I am able to explain you

thanks

Not applicable
Author

Not applicable
Author

Hi sunindia

Did you have any solution to above situation?

sunny_talwar

I don't Sumit. I am not entirely grasping the requirement here. I am sorry brother.