Help: Spending language SQL Access to the Script QLIKVIEW (Aide : Passer du language SQL Access au Script QLIKVIEW)

[#1]

Hello everyone,

I am new user of this software that I find great.

I was training designer and all those who graph and expressions I'm doing.

However, I need help with the script because I'm a little blue.

Here I have to basically turn a lanquage ACCESS SQL script in QLIKVIEW edition:

Below the SQL:

"Create view dbo.v_Dossier

ace

select

Dossier.dos_id,

Dossier.dos_ste,

Dossier.dos_cnt,

Dossier.dos_libelle,

Dossier.dos_datdeb,

Dossier.dos_hdeb,

Dossier.dos_oper_deb,

Dossier.dos_datfin,

Dossier.dos_hfin,

Dossier.dos_oper_fin,

Dossier.dos_struct,

Dossier.dos_hmaj,

Dossier.dos_oper_maj,

Dossier.dos_libelle2,

Dossier.dos_metier,

Dossier.dos_activ,

Dossier.dos_robot,

Dossier.dos_xfic,

Dossier.dos_xcle,

Dossier.dos_formulaire,

Dossier.dos_scenario,

Dossier.dos_decalhor,

Dossier.dos_zgeo,

Dossier.dos_preneur_ste,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'Information') as Information,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'SansDroit') as SansDroit,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'SansSuite') as SansSuite,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'Administration') as Administrative,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'Technique') as technique,

(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom

= 'Cancel') as Cancels,

hut

    when (select count (*) from Event Where ev_pere = Dossier.dos_activ

and ev_nom = 'Cancel')> 0 then 'Undo'

    else

    hut

    when (select count (*) from Event Where ev_pere = Dossier.dos_activ

and ev_nom = 'Technique')> 0 then 'Technical'

    else

       hut

       when (select count (*) from Event Where ev_pere =

Dossier.dos_activ and ev_nom = 'Administration')> 0 then 'Administrative'

       else

          hut

          when (select count (*) from Event Where ev_pere =

Dossier.dos_activ and ev_nom = 'SansSuite')> 0 then 'SansSuite'

          else

             hut

             when (select count (*) from Event Where ev_pere =

Dossier.dos_activ and ev_nom = 'SansDroit')> 0 then 'SansDroit'

             else

                'Information'

             end

          end

       end

    end

end as type_dossier

from Dossier

Where dos_robot is not null "

Someone could help me please ?????

HELP

THANK YOU

Alex

Translated with Google Translate - Qlik Community Administrative Team

Bonjour à tous,

Je suis nouveau utilisateur de ce logiciel que je trouve super bien .

J'ai eu la formation Concepteur et pour tous ceux qui est graph et expressions, je m'en sors.

Cependant, j'ai besoin d'aide pour les script car je suis un peu bleu.

Voila je dois en gros transformer un lanquage SQL ACCESS en edition script QLIKVIEW :

Ci dessous le SQL:

"create view dbo.v_Dossier

as

select
Dossier.dos_id,
Dossier.dos_ste,
Dossier.dos_cnt,
Dossier.dos_libelle,
Dossier.dos_datdeb,
Dossier.dos_hdeb,
Dossier.dos_oper_deb,
Dossier.dos_datfin,
Dossier.dos_hfin,
Dossier.dos_oper_fin,
Dossier.dos_struct,
Dossier.dos_hmaj,
Dossier.dos_oper_maj,

Dossier.dos_libelle2,
Dossier.dos_metier,
Dossier.dos_activ,
Dossier.dos_robot,
Dossier.dos_xfic,
Dossier.dos_xcle,
Dossier.dos_formulaire,
Dossier.dos_scenario,
Dossier.dos_decalhor,
Dossier.dos_zgeo,
Dossier.dos_preneur_ste,

(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'Information') as Information,
(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'SansDroit') as SansDroit,
(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'SansSuite') as SansSuite,
(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'Administratif') as Administratif,
(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'Technique') as Technique,
(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom
= 'Annule') as Annule,

case
    when (select count(*) from Event where ev_pere = Dossier.dos_activ
and ev_nom = 'Annule') > 0 then 'Annule'
    else
    case
    when (select count(*) from Event where ev_pere = Dossier.dos_activ
and ev_nom = 'Technique') > 0 then 'Technique'
    else
       case
       when (select count(*) from Event where ev_pere =
Dossier.dos_activ and ev_nom = 'Administratif') > 0 then 'Administratif'
       else
          case
          when (select count(*) from Event where ev_pere =
Dossier.dos_activ and ev_nom = 'SansSuite') > 0 then 'SansSuite'
          else
             case
             when (select count(*) from Event where ev_pere =
Dossier.dos_activ and ev_nom = 'SansDroit') > 0 then 'SansDroit'
             else
                'Information'
             end
          end
       end
    end
end as type_dossier

from Dossier
where dos_robot is not null"

Quelqu'un pourrait il m'aider svp?????

A L'AIDE

MERCI

Alex