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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sanliza
Contributor
Contributor

Is it ok if there are 2 semicolon before STORE when creating a qvd?

Hello, I am analyzing a code and I came across 2 semicolons before STORE when creating a qvd file. Do you know if this is going to cause any kind of conflict or missing data. So far the app works fine, I am concerned about the data saved in the qvd file. Thanks

...

FROM "TableTest" 
WHERE
Code NOT LIKE 'L5568' ;;

Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);

1 Solution

Accepted Solutions
stevejoyce
Specialist II
Specialist II

it's not going to impact it.  your table loaded in memory is done after the first semi-colon.  and a separate statement stores it.  for example you could have below.  This vVariable has no impact on the storing.

FROM "TableTest" 
WHERE
Code NOT LIKE 'L5568' ;;

 

let vVariable = Today();

 

Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);

View solution in original post

3 Replies
stevejoyce
Specialist II
Specialist II

No,  ; is just the end of a statement.  it's like your closing out no statement after the first semi-colon.

Sanliza
Contributor
Contributor
Author

Thank you! Do you know how can this impact the data stored in the QVD file? I cannot  reload the data yet to compare...

stevejoyce
Specialist II
Specialist II

it's not going to impact it.  your table loaded in memory is done after the first semi-colon.  and a separate statement stores it.  for example you could have below.  This vVariable has no impact on the storing.

FROM "TableTest" 
WHERE
Code NOT LIKE 'L5568' ;;

 

let vVariable = Today();

 

Store SalesTest into [lib://$(vS2)/SalesTest.qvd] (qvd);