3 Replies Latest reply: Feb 17, 2014 11:12 AM by Tobias Paulini RSS

    Problems with Thousand and Decimal Separator

    Tobias Paulini

      Hi,

       

      we are using QlikView to load different Excel files or .txt files.

       

      Some of them have a German Seperator Logic, like . for Thousands and , for Thousands and others are English.

      So the seperaters are switched.

       

      We tryed to solve this by using mulitple times the Script command:

       

      SET ThousandSep='.';

      SET DecimalSep=',';

       

      or the other way around, each time before we load another file.

       

      But this does not solve our problem. When we load the Englisch files we get no the right numbers in QlikView. Do you have an tips for me?