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

topic Help: Spending language SQL Access to the Script QLIKVIEW (Aide : Passer du language SQL Access au Script QLIKVIEW) in QlikView https://community.qlik.com/t5/QlikView/Help-Spending-language-SQL-Access-to-the-Script-QLIKVIEW-Aide/m-p/847895#M655325 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am new user of this software that I find great.</P><P></P><P>I was training designer and all those who graph and expressions I'm doing.</P><P></P><P>However, I need help with the script because I'm a little blue.</P><P></P><P>Here I have to basically turn a lanquage ACCESS SQL script in QLIKVIEW edition:</P><P></P><P>Below the SQL:</P><P>"Create view dbo.v_Dossier</P><P></P><P>ace</P><P></P><P>select</P><P>Dossier.dos_id,</P><P>Dossier.dos_ste,</P><P>Dossier.dos_cnt,</P><P>Dossier.dos_libelle,</P><P>Dossier.dos_datdeb,</P><P>Dossier.dos_hdeb,</P><P>Dossier.dos_oper_deb,</P><P>Dossier.dos_datfin,</P><P>Dossier.dos_hfin,</P><P>Dossier.dos_oper_fin,</P><P>Dossier.dos_struct,</P><P>Dossier.dos_hmaj,</P><P>Dossier.dos_oper_maj,</P><P></P><P></P><P>Dossier.dos_libelle2,</P><P>Dossier.dos_metier,</P><P>Dossier.dos_activ,</P><P>Dossier.dos_robot,</P><P>Dossier.dos_xfic,</P><P>Dossier.dos_xcle,</P><P>Dossier.dos_formulaire,</P><P>Dossier.dos_scenario,</P><P>Dossier.dos_decalhor,</P><P>Dossier.dos_zgeo,</P><P>Dossier.dos_preneur_ste,</P><P></P><P></P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Information') as Information,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'SansDroit') as SansDroit,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'SansSuite') as SansSuite,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Administration') as Administrative,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Technique') as technique,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Cancel') as Cancels,</P><P></P><P></P><P>hut</P><P>    when (select count (*) from Event Where ev_pere = Dossier.dos_activ</P><P>and ev_nom = 'Cancel')> 0 then 'Undo'</P><P>    else</P><P>    hut</P><P>    when (select count (*) from Event Where ev_pere = Dossier.dos_activ</P><P>and ev_nom = 'Technique')> 0 then 'Technical'</P><P>    else</P><P>       hut</P><P>       when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'Administration')> 0 then 'Administrative'</P><P>       else</P><P>          hut</P><P>          when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'SansSuite')> 0 then 'SansSuite'</P><P>          else</P><P>             hut</P><P>             when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'SansDroit')> 0 then 'SansDroit'</P><P>             else</P><P>                'Information'</P><P>             end</P><P>          end</P><P>       end</P><P>    end</P><P>end as type_dossier</P><P></P><P></P><P>from Dossier</P><P>Where dos_robot is not null "</P><P>Someone could help me please ?????</P><P>HELP</P><P></P><P>THANK YOU</P><P></P><P>Alex</P><P></P><P><STRONG>Translated with Google Translate - Qlik Community Administrative Team</STRONG></P><P></P><P>Bonjour à tous,</P><P></P><P>Je suis nouveau utilisateur de ce logiciel que je trouve super bien <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>J'ai eu la formation Concepteur et pour tous ceux qui est graph et expressions, je m'en sors.</P><P></P><P>Cependant, j'ai besoin d'aide pour les script car je suis un peu bleu.</P><P></P><P>Voila je dois en gros transformer un lanquage SQL ACCESS en edition script QLIKVIEW :</P><P></P><P>Ci dessous le SQL:</P><P><SPAN style="font-size: 10pt;">"create view dbo.v_Dossier<BR /><BR />as<BR /><BR />select<BR />Dossier.dos_id,<BR />Dossier.dos_ste,<BR />Dossier.dos_cnt,<BR />Dossier.dos_libelle,<BR />Dossier.dos_datdeb,<BR />Dossier.dos_hdeb,<BR />Dossier.dos_oper_deb,<BR />Dossier.dos_datfin,<BR />Dossier.dos_hfin,<BR />Dossier.dos_oper_fin,<BR />Dossier.dos_struct,<BR />Dossier.dos_hmaj,<BR />Dossier.dos_oper_maj,<BR /><BR />Dossier.dos_libelle2,<BR />Dossier.dos_metier,<BR />Dossier.dos_activ,<BR />Dossier.dos_robot,<BR />Dossier.dos_xfic,<BR />Dossier.dos_xcle,<BR />Dossier.dos_formulaire,<BR />Dossier.dos_scenario,<BR />Dossier.dos_decalhor,<BR />Dossier.dos_zgeo,<BR />Dossier.dos_preneur_ste,<BR /><BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Information') as Information,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'SansDroit') as SansDroit,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'SansSuite') as SansSuite,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Administratif') as Administratif,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Technique') as Technique,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Annule') as Annule,<BR /><BR />case<BR />    when (select count(*) from Event where ev_pere = Dossier.dos_activ<BR />and ev_nom = 'Annule') > 0 then 'Annule'<BR />    else<BR />    case<BR />    when (select count(*) from Event where ev_pere = Dossier.dos_activ<BR />and ev_nom = 'Technique') > 0 then 'Technique'<BR />    else<BR />       case<BR />       when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'Administratif') > 0 then 'Administratif'<BR />       else<BR />          case<BR />          when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'SansSuite') > 0 then 'SansSuite'<BR />          else<BR />             case<BR />             when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'SansDroit') > 0 then 'SansDroit'<BR />             else<BR />                'Information'<BR />             end<BR />          end<BR />       end<BR />    end<BR />end as type_dossier<BR /><BR />from Dossier<BR />where dos_robot is not null"<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Quelqu'un pourrait il m'aider svp?????</SPAN></P><P><SPAN style="font-size: 10pt;">A L'AIDE</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">MERCI</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Alex</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 06:42:13 GMT 2015-06-18T06:42:13Z Help: Spending language SQL Access to the Script QLIKVIEW (Aide : Passer du language SQL Access au Script QLIKVIEW) https://community.qlik.com/t5/QlikView/Help-Spending-language-SQL-Access-to-the-Script-QLIKVIEW-Aide/m-p/847895#M655325 <HTML><HEAD></HEAD><BODY><P>Hello everyone,</P><P></P><P>I am new user of this software that I find great.</P><P></P><P>I was training designer and all those who graph and expressions I'm doing.</P><P></P><P>However, I need help with the script because I'm a little blue.</P><P></P><P>Here I have to basically turn a lanquage ACCESS SQL script in QLIKVIEW edition:</P><P></P><P>Below the SQL:</P><P>"Create view dbo.v_Dossier</P><P></P><P>ace</P><P></P><P>select</P><P>Dossier.dos_id,</P><P>Dossier.dos_ste,</P><P>Dossier.dos_cnt,</P><P>Dossier.dos_libelle,</P><P>Dossier.dos_datdeb,</P><P>Dossier.dos_hdeb,</P><P>Dossier.dos_oper_deb,</P><P>Dossier.dos_datfin,</P><P>Dossier.dos_hfin,</P><P>Dossier.dos_oper_fin,</P><P>Dossier.dos_struct,</P><P>Dossier.dos_hmaj,</P><P>Dossier.dos_oper_maj,</P><P></P><P></P><P>Dossier.dos_libelle2,</P><P>Dossier.dos_metier,</P><P>Dossier.dos_activ,</P><P>Dossier.dos_robot,</P><P>Dossier.dos_xfic,</P><P>Dossier.dos_xcle,</P><P>Dossier.dos_formulaire,</P><P>Dossier.dos_scenario,</P><P>Dossier.dos_decalhor,</P><P>Dossier.dos_zgeo,</P><P>Dossier.dos_preneur_ste,</P><P></P><P></P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Information') as Information,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'SansDroit') as SansDroit,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'SansSuite') as SansSuite,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Administration') as Administrative,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Technique') as technique,</P><P>(Select count (*) from Event Where ev_pere = Dossier.dos_activ and ev_nom</P><P>= 'Cancel') as Cancels,</P><P></P><P></P><P>hut</P><P>    when (select count (*) from Event Where ev_pere = Dossier.dos_activ</P><P>and ev_nom = 'Cancel')> 0 then 'Undo'</P><P>    else</P><P>    hut</P><P>    when (select count (*) from Event Where ev_pere = Dossier.dos_activ</P><P>and ev_nom = 'Technique')> 0 then 'Technical'</P><P>    else</P><P>       hut</P><P>       when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'Administration')> 0 then 'Administrative'</P><P>       else</P><P>          hut</P><P>          when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'SansSuite')> 0 then 'SansSuite'</P><P>          else</P><P>             hut</P><P>             when (select count (*) from Event Where ev_pere =</P><P>Dossier.dos_activ and ev_nom = 'SansDroit')> 0 then 'SansDroit'</P><P>             else</P><P>                'Information'</P><P>             end</P><P>          end</P><P>       end</P><P>    end</P><P>end as type_dossier</P><P></P><P></P><P>from Dossier</P><P>Where dos_robot is not null "</P><P>Someone could help me please ?????</P><P>HELP</P><P></P><P>THANK YOU</P><P></P><P>Alex</P><P></P><P><STRONG>Translated with Google Translate - Qlik Community Administrative Team</STRONG></P><P></P><P>Bonjour à tous,</P><P></P><P>Je suis nouveau utilisateur de ce logiciel que je trouve super bien <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P><P></P><P>J'ai eu la formation Concepteur et pour tous ceux qui est graph et expressions, je m'en sors.</P><P></P><P>Cependant, j'ai besoin d'aide pour les script car je suis un peu bleu.</P><P></P><P>Voila je dois en gros transformer un lanquage SQL ACCESS en edition script QLIKVIEW :</P><P></P><P>Ci dessous le SQL:</P><P><SPAN style="font-size: 10pt;">"create view dbo.v_Dossier<BR /><BR />as<BR /><BR />select<BR />Dossier.dos_id,<BR />Dossier.dos_ste,<BR />Dossier.dos_cnt,<BR />Dossier.dos_libelle,<BR />Dossier.dos_datdeb,<BR />Dossier.dos_hdeb,<BR />Dossier.dos_oper_deb,<BR />Dossier.dos_datfin,<BR />Dossier.dos_hfin,<BR />Dossier.dos_oper_fin,<BR />Dossier.dos_struct,<BR />Dossier.dos_hmaj,<BR />Dossier.dos_oper_maj,<BR /><BR />Dossier.dos_libelle2,<BR />Dossier.dos_metier,<BR />Dossier.dos_activ,<BR />Dossier.dos_robot,<BR />Dossier.dos_xfic,<BR />Dossier.dos_xcle,<BR />Dossier.dos_formulaire,<BR />Dossier.dos_scenario,<BR />Dossier.dos_decalhor,<BR />Dossier.dos_zgeo,<BR />Dossier.dos_preneur_ste,<BR /><BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Information') as Information,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'SansDroit') as SansDroit,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'SansSuite') as SansSuite,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Administratif') as Administratif,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Technique') as Technique,<BR />(select count(*) from Event where ev_pere = Dossier.dos_activ and ev_nom<BR />= 'Annule') as Annule,<BR /><BR />case<BR />    when (select count(*) from Event where ev_pere = Dossier.dos_activ<BR />and ev_nom = 'Annule') > 0 then 'Annule'<BR />    else<BR />    case<BR />    when (select count(*) from Event where ev_pere = Dossier.dos_activ<BR />and ev_nom = 'Technique') > 0 then 'Technique'<BR />    else<BR />       case<BR />       when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'Administratif') > 0 then 'Administratif'<BR />       else<BR />          case<BR />          when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'SansSuite') > 0 then 'SansSuite'<BR />          else<BR />             case<BR />             when (select count(*) from Event where ev_pere =<BR />Dossier.dos_activ and ev_nom = 'SansDroit') > 0 then 'SansDroit'<BR />             else<BR />                'Information'<BR />             end<BR />          end<BR />       end<BR />    end<BR />end as type_dossier<BR /><BR />from Dossier<BR />where dos_robot is not null"<BR /></SPAN></P><P><SPAN style="font-size: 10pt;">Quelqu'un pourrait il m'aider svp?????</SPAN></P><P><SPAN style="font-size: 10pt;">A L'AIDE</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">MERCI</SPAN></P><P></P><P><SPAN style="font-size: 10pt;">Alex</SPAN></P></BODY></HTML> Thu, 18 Jun 2015 06:42:13 GMT https://community.qlik.com/t5/QlikView/Help-Spending-language-SQL-Access-to-the-Script-QLIKVIEW-Aide/m-p/847895#M655325 2015-06-18T06:42:13Z