Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
priyasawant
Creator II
Creator II

Creating new QVD on each reload

Hi,

I have a data set connection want different QVD to create after each reload.

For e.g,

Tab:

Load *,

From $(vpath);

store Tab into $(vstorepath);

After each reload I should get a new QVD as QVD_1,QVD_2,QVD_3,QVD_4 and so on

Output in the Folder should look like,

QVD_1.qvd

QVD_2.qvd

QVD_3.qvd

QVD_4.qvd

 

and so on......

2 Solutions

Accepted Solutions
MayilVahanan

Hi @priyasawant 

Try like below

If QvdCreateTime('T_*.qvd') then
Let vRow = 1;

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

T:
Load * from yoursource;

store T into T_$(vRow).qvd(qvd);

Let vNextRow = $(vRow) +1;

Change the table and qvd name based on ur datamodel.

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.

View solution in original post

priyasawant
Creator II
Creator II
Author

@MayilVahanan 

 

Thank you so much for the response.

 

i am getting error while loading the below...

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

View solution in original post

4 Replies
MayilVahanan

Hi @priyasawant 

Try like below

If QvdCreateTime('T_*.qvd') then
Let vRow = 1;

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

T:
Load * from yoursource;

store T into T_$(vRow).qvd(qvd);

Let vNextRow = $(vRow) +1;

Change the table and qvd name based on ur datamodel.

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
priyasawant
Creator II
Creator II
Author

@MayilVahanan 

 

Thank you so much for the response.

 

i am getting error while loading the below...

else
Let vRow = if($(vNextRow) = 0, 1, $(vNextRow));
ENDIF;

MayilVahanan

Hi @priyasawant 

Do you have the qvd already?
In that case, it throws error for first time. 
Either delete the qvd in the folder or ignore the error for the first time. 

Thanks & Regards,
Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
priyasawant
Creator II
Creator II
Author

Unexpected token error