12 Replies Latest reply: Dec 11, 2013 7:31 AM by Chanel Choo RSS

    Count distinct is not working in script?

      Dear community,


      I found problem for script below, the FlightNumber is always showing 1...



      Load Fltno,

          [Flt Dt],

          Count(distinct Fltno) * Count(distinct [Flt Dt])) as FlightNumber

      resident FlightData

      group by [Flt Dt], Fltno;


      I think count distinct might not work in this way in script, anyone knows to workaround to overcome this?

      it is working fine in expression in chart.



      For special reason, i cannot have expression in the chart, i need a (number of flight) field,

      so that the chart can directly use the field.

      (limitation of GeoQlik flow chart, only can use field, expression is not working)

      I need the number of flight field can corresponding to the filter selection. just like the figure show in blue text box.



      Thanks and best regards,