topic Re: conition if ,boucle where . in QlikView

conition if ,boucle where .

Mon, 21 Oct 2013 16:29:00 GMT

Hello,

I created a view, this was Last chargée.Mais Where I want to use the loop.

example: where column_name = 'TEST' and 'TEST1';

do I know my loop or placed after the selection.

Re: conition if ,boucle where .

Gysbert_Wassenaar — Mon, 21 Oct 2013 17:17:10 GMT

A wild guess since I don't understand what you're asking:

TableA:

Load *

From mysourcetable

Where match(column_name, 'TEST','TEST1');

If that's not what you're looking for please explain in more detail or simply post your question in French so Google Translate can try to make English of it. Or perhaps post here instead: Groupe des Utilisateurs Francophones

Re: conition if ,boucle where .

Tue, 22 Oct 2013 09:21:52 GMT

Bonjour ,

J'ai créé une vue, on la chargeant avec l'instruction Load,mais je voudrai utilisé la clause Where,on faisant .

load nfac as 'numéro facture',

sec as section,

cori as origine ,

seclect* from vue_fact

where cori='Vvente' and 'Vachat';

Merci e m'aider .

Re: conition if ,boucle where .

Gysbert_Wassenaar — Tue, 22 Oct 2013 10:03:07 GMT

Try:

load NFAC as 'invoice number'

Dry as section

cori as originally

seclect * from vue_fact

Where cori = 'Vvente' or cori = 'Vachat';