12 Replies Latest reply: Sep 16, 2016 6:09 AM by Jonathan Dienst RSS

    Group by and count doesn't work

    Robert Ebner

      Hi all,

      i have the following problem and don’t get the answer – even it should be very easy:

      I have this table:

       

      Alter

      ID

      4

      23432423

      3

      234234234

      2

      234234

      4

      234234234

      3

      234234234

      2

      234234234

      1

      324234234

       

      Now I want to group by “Alter” and count the number of IDs.

      Result should be:

       

      Alter

      Counted ID

      1

      1

      2

      2

      3

      2

      4

      2

       

      Warteschlange:
      LOAD Distinct
      Alter,
      count(distinct ID) as Anzahl_Warteschlange
      Resident Datenload_Datum
      Group by Alter;

       

      The problem is, that QlikView doesn’t do the group by.

      Can you help?

      Thank u very much!