3 Replies Latest reply: Mar 1, 2011 11:06 AM by AndreaPeretti RSS

    different value of a concatenate field with qlik10.

      different value of a concatenate field with qlik10.
      if reload file.qvw with qlik9 or qlik10 the field keyCosto_New takes on different values.

      Can you tell me if it happens to you?

      I can not insert a file.qvw.


      script:

      set data_costo = date(date#(CSTDATE,'YYYYMMDD'));

      Test:
      LOAD * INLINE [
      CSTDATE, SOC, ITEM, COST,
      20100201, soc, pippo, 1,
      20100301, soc, mario, 1,
      ];

      Test_1:
      LOAD
      SOC &'-'& ITEM &'-'& COST as keyCosto,
      ITEM,
      COST,
      SOC,
      max($(data_costo)) as MAX_CSTDATE
      resident Test
      group by SOC,ITEM,COST;
      drop table Test;

      Test_2:
      LOAD *,
      keyCosto &'-'& MAX_CSTDATE as keyCosto_New
      resident Test_1;

      drop table Test_1;

       

      Thanks