Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

Problem QVD

Hello,

I have this code and i want to use QVD and concatenate data :

SET vQvdPath=C:\Users\administrateur.VECTORYS\Desktop\Zied\qvdtest\New;

Flotte:

   

   

LOAD Plate as Plaque_flotte,

Today() as date_flotte,

TrailerType as Materiel_flotte,

  ParkName as Parc_flotte,

  SATUT as stat_flotte;

   

//[CG_FLOTTE_Suivi_Echeances]:

SELECT Plate,

TrailerType,

  ParkName,

  SATUT

FROM

NoConcatenate

Plaque_all:

load Distinct Plaque,

'1' as statut_inactif,

Type_Materiel as Materiel_flotte,

Today() as date_flotte

resident Fact_Final Where NOT Exists(Plaque_flotte,Plaque) and Type_Materiel<>'DiversMateriel';

Concatenate

Flotte1:

Load

   Plaque_flotte ,

   Materiel_flotte,

   date_flotte,

   

  if(stat_flotte='ACTIF',1,0) as statut_actif,

   

         

               if(stat_flotte='INACTIF',1,0)  as statut_endom,

        if(stat_flotte='BLOQUE',1,0)  as statut_bloque

    Resident Flotte;

    drop table Flotte;

NoConcatenate

    Flotte2:

  

    load

    //stat_flotte,

   Plaque,

         date_flotte,

         Materiel_flotte,

      Plaque_flotte as Plaque_flotte,

        sum(statut_endom) as statut_endom,

       

       // statut_active,

         sum(statut_actif)  as statut_actif,

       sum(statut_inactif)  as statut_inactif,

     

                                       //ici

        sum(statut_bloque)  as statut_bloque,

       (sum(statut_actif)/day(date_flotte)) as Taux

        resident Plaque_all

      

      Group by date_flotte,Materiel_flotte,Plaque_flotte,Plaque

      ;

     

       

      drop table Plaque_all;

  

   

 

NoConcatenate

      

    Flotte3:

    load

 

    Plaque,

    statut_inactif,

    statut_bloque,

    statut_endom,

    date_flotte,

   Plaque_flotte as Plaque_flotte,

   Materiel_flotte,

   

    if (statut_actif>statut_bloque and statut_actif>statut_inactif,1,

    (if(statut_bloque>statut_actif and statut_bloque>statut_inactif,2,

    (IF(statut_inactif>statut_actif and statut_inactif>statut_bloque,3))))) as Statut_cond,

   

     Taux ,

               

   statut_actif

 

 

  

    Resident Flotte2

  

    ;

    drop table Flotte2;

    

NoConcatenate

    Flotte4:

  

    load

   Plaque,

 

   statut_actif,

    date_flotte,

    statut_inactif,

    statut_bloque,

    statut_endom,

    //Statut_sup,

         Plaque_flotte as Plaque_flotte,

         Materiel_flotte,

         Taux,

   

   

     if (Statut_cond=1,'Actif',

    (if (Statut_cond=2,'Bloquée',

    (IF(Statut_cond=3,'Inactif'))))) as Statut_sup

   

 

    Resident Flotte3;

    drop table Flotte3;

 

//pour SR sans traversée

    NoConcatenate

    FlotteFinal:

  

 

    LOAD Plaque,

    

        date_flotte,

         Plaque_flotte as Plaque_flotte,

         Materiel_flotte FROM (qvd) ;//source des QVDs historisés

Concatenate:

LOAD

    * WHERE  "date_flotte"= Today();

    load

   //Plaque,

    date_flotte,

  

          Plaque_flotte as Plaque_flotte,

         Materiel_flotte,

         Taux,

         'ON'  as STATUT,

         count(Statut_sup) as nbr

         resident Flotte4

         where Statut_sup='Actif'

         group by

        date_flotte,

         Taux,

         //[%Date ID],

         Plaque_flotte,

         Materiel_flotte;

      

       

         Concatenate  

           load

      Plaque,

     

        date_flotte,

         Plaque_flotte as Plaque_flotte,

         Materiel_flotte,

           'OFF'  as STATUT,

         count(Statut_sup) as nbr

         resident Flotte4

         where Statut_sup='Inactif'

         group by  date_flotte,

         Plaque_flotte,

         Materiel_flotte,Plaque;

        

     

          Concatenate  

           load

       date_flotte,

     

         Plaque_flotte as Plaque_flotte,

         Materiel_flotte,

          'Bloquée'  as STATUT,

         count(Statut_sup) as nbr

         resident Flotte4

         where Statut_sup='Bloquée'

         group by  date_flotte,

         Plaque_flotte,

         Materiel_flotte;

drop table Flotte4;

          Concatenate

             Load*

             resident Fact_Final ;

             drop table Fact_Final;

           

STORE [FlotteFinal] into [$(vQvdPath)\QVD_final.qvd.qvd](qvd);

I would like to stoke data of the last table but the problem i have synthetic keys after the concatenate

Regards

6 Replies
zied_ahmed1
Contributor III

Re: Problem QVD

zied_ahmed1
Contributor III

Re: Problem QVD

jagan

rahulpawarb
Valued Contributor III

Re: Problem QVD

Hello Zied,

As per the given script Table FlotteFinal will the single table present in the data model. Could you please provide the data model screenshot or complete script? This will help us to identify the issue and provide you expected results.

Regards!

Rahul

zied_ahmed1
Contributor III

Re: Problem QVD

Hello Rahul,

modéle.png

this is the modele and this is the flotte_finale that i want store it every day

rahulpawarb
Valued Contributor III

Re: Problem QVD

I could not see any synthetic key in given screenshot. What exact problem you are facing while pushing the result to QVD.

Regards!

Rahul

zied_ahmed1
Contributor III

Re: Problem QVD

yes because i reload without the code of concatenation,

i find my solution i write Concatenate: and i need just Concatenate a very small error thank you

Community Browser