Currently using Qlik Sense April 2020 Enterprise. I am looking to use a variable to restrict the data and create multiple QVD files.I would like to run some sort of a While loop which will run until all the variable values are used and QVD's created for each variable value.
$(Variable) =A,B,C ........
Were Field =$(variable)
Store Data_Table into \\Serve1\$(variable)\Data_Table.qvd
Thanx for the solution. I have one more requirement to add. Once this loadd is done . I am dropping the table but still would like to get the row count for each v. I tried the below statement but it didnt work. Any Ideas?
Were Field ='$(v)'
Let vRowCount_Data_Table_$(v) =NoofRows('Data_Table_$(v)')
Store Data_Table into \\Serve1\$(v)\Data_Table.qvd;