Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Is there a way to use loops on a SQL table-valued function parameter in Qlik?

I am trying to use a function with one of the parameters to be changed and take these values:

14 18 22 67 77 86 94 114 141 145 150 189 242 246 251 312 316 345 349 359 431 435 439 443 457 470 474 482 489 493 516 836 538 551

Is there a way I can proceed to make a table containing the output from all of these?

declare @item_id int =14

select * from abc.get_data(32,@item_id,'19000101','99991231')

0 Replies