Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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

Community Browser