Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Clause Where

Bonjour,

Je travaille actuellement sur Q11 et test actuellement le chargement incrémental.

Je ne comprend pas trop pourquoi la clause WHERE ne fonctionne pas ici.

Les données de mon QVD.

test2.png

Je veux récupérer les chacune des colonnes modifiés à l'aide du champ date_modification

test.png

Catastrophe lors du chargement des données :

3.png

Je ne vois pas ce qui pose problème. Merci par avance.

Cdt,

RR

1 Solution

Accepted Solutions
Master III
Master III

Since QVD file is empty, null is assigned to vLastUpdate. Do you have any data in QVD?

In Where clause use quotes around variable vLastUpdate

Where DATE_NOTIFICATION > '$(vLastUpdate)'

View solution in original post

3 Replies
Master III
Master III

Since QVD file is empty, null is assigned to vLastUpdate. Do you have any data in QVD?

In Where clause use quotes around variable vLastUpdate

Where DATE_NOTIFICATION > '$(vLastUpdate)'

View solution in original post

Not applicable

My QVD is not empty. But you are right!

I don't understand why you need this quote here. Could you explain me?

Master III
Master III

Quotes are required for Dates and String literals. It is not required for integer