2 Replies Latest reply: Jul 19, 2016 12:15 PM by Rui Esteves RSS

    Qliksense modifying data

    Rui Esteves

      Hello,

      I am puzzled with a Qlik Sense Desktop behaviour.

      It happens on one of my PCs and not on another.

       

      I have a table with:

       

      WAREHOUSE:

      LOAD * INLINE [

      Code, Description

      '06', "Room 06"

      'R6', "Room R6"];

       

      LOAD

      Code as WH,

      Description as Nome

      RESIDENT WAREHOUSE;

      DROP TABLE WAREHOUSE;

       

      The resulting table is:

      WH, Nome

      06, Room 06

      06, Room R6

       

      On the other computer, the result is correct:

      WH, Nome

      06, Room 06

      R6, Room R6

       

      What computer configuration might be changing the data?

       

      Thanks

       

      Rui

        • Re: Qliksense modifying data
          Gysbert Wassenaar

          What computer configuration might be changing the data?

          None. This must be another error. Check that you didn't make a typo in the script. If you're really really sure that the exact same app behaves differently on two different machines then post that app here.

            • Re: Qliksense modifying data
              Rui Esteves

              Thanks Gysbert.

               

              But I just found that this is a bug of Qlik Sense.

              The PC with strange behavior has as Main setting for currency (it is in Brazil):

                        SET MoneyFormat='R$ #.##0,00;-R$ #.##0,00';

              If I change to not have the R at the begining, it stops converting R6 into 06.

              It seems that it is interpreting the $ as an wildchar.