topic Re: language script in QlikView

language script

Thu, 23 Apr 2015 13:43:23 GMT

Bonjour,

J'aurai besoin d'aide afin de créer des variables depuis le script qlikview.

Les variables à créer sont id_BAP et ID_ANNULE;

( select max(ev_id) from Event where ev_pere = Prestation.pst_activ and ev_nom = 'BAP' ) as id_BAP,

( select max(ev_id) from Event where ev_pere = Prestation.pst_activ and ev_nom = 'AnnulePrestation' ) as id_Annule

J'ai le script en language SQL (recopie depuis ACCESS) cependant je voulais savoir comment l’écrire dans Qlikview?

( select max(ev_id) from Event where ev_pere = Prestation.pst_activ and ev_nom = 'BAP' ) as id_BAP,
( select max(ev_id) from Event where ev_pere = Prestation.pst_activ and ev_nom = 'AnnulePrestation' ) as id_Annule

Re: language script

oknotsen — Thu, 23 Apr 2015 14:11:15 GMT

From google translate:

Hello,

I need help to create variables from the QlikView script.

Variables are created id_BAP and ID_ANNULE;

(Select max (EV_ID) from Event Where ev_pere = Prestation.pst_activ and ev_nom = 'BAP') as id_BAP,

(Select max (EV_ID) from Event Where ev_pere = Prestation.pst_activ and ev_nom = 'AnnulePrestation') as id_Annule

I have the script language SQL (copied from ACCESS) However, I wanted to know how to write in QlikView?

(Select max (EV_ID) from Event Where ev_pere = Prestation.pst_activ and ev_nom = 'BAP') as id_BAP,

(Select max (EV_ID) fromEventWhereev_pere=Prestation.pst_activandev_nom= 'AnnulePrestation') as id_Annule

Re: language script

Anonymous — Thu, 23 Apr 2015 14:26:56 GMT

tab1:
Select max (EV_ID) as Field1 from Event Where ev_pere = Prestation.pst_activ and ev_nom = 'BAP';

LET id_BAP=peek('Field1');
DROP TABLE tab1;

tab2:
Select max (EV_ID) as Field2 from EventWhereev_pere=Prestation.pst_activandev_nom= 'AnnulePrestation';

LET id_Annule=peek('Field2');
DROP TABLE tab2;