0 Replies Latest reply: Jul 27, 2015 4:22 PM by Alexandre BOYER RSS

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

    Alexandre BOYER

      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