2 Replies Latest reply: Jan 28, 2016 4:47 AM by Dorothée Bavière RSS

    Delete a column

    Dorothée Bavière

      Hello community 

      I have a small problem on QlikView :

      I have a table on Qlik where the dimension is " fam_risque " and the expression is " source_choisie " : I name this table ' tb_source_choisie '

       

      Fam_risque

      SANTE

      PREV

       

      CC

      INFOCENTRE

       

      Then I export this table in CSV with a VB Macro script :

       

      Sub Source

       

      path = "C:\WORK"
      Set table_calcul_temp = ActiveDocument.GetSheetObject("tb_source_choisie")
      table_calcul_temp.Export path&"\source_choisie.csv",";",0

       

      End Sub

       

      So I have an excel in my file 'WORK'  : 'source_choisie.csv ' :

       

      fam_risque

      SANTE

      PREV

       

      CC

      INFOCENTRE

       

      Except that I would delete the first column ... How with a Macro VB script ? What should I use ?I can't delete the first column on Qlik ..

       

       

      Thanks for your answers.

       

      Dorothée