9 Replies Latest reply: Mar 21, 2016 7:17 AM by Ali Hijazi RSS

    Weird result in Qlikview

      I have a script in qlikview like this:

      SQL select f.periode as PERIOD, f.turnover as turnover from tablename f;

      In my result I see that i have like this below:

      Period turnover 
              55555 
                66666
               11111,00 
                454.5456 
      201601 
      201509 
      201503
       201605

      I executed this sql statement in my database

      I found :

      Period     turnover

      201601    55555

      201509    66666

      201503   11111.00

      Your help is very appreciated, Thank you