1 Reply Latest reply: Apr 10, 2013 9:55 AM by Gysbert Wassenaar RSS

    Counting items in a Straight Table

      Hi,

       

      My Qlikview Document has a straight table, in which an expression exists that only shows data if the field level3desc_probcode = 'Maximo' or 'Syclo'.  I then have 2 List Box, one which allows me to view Open or Closed Calls and the other which allows me to view just Maximo or just Syclo Calls.

       

      However I need to do a count of the items in the Straight table and put it in a text object.  However say there are 100 items in the field, 90 of them are Maximo 10 are Syclo.  I need it so if I click the Maximo List Box, then the text objects shows as 90, and if I select the Syclo then the text object shows as 10.

       

      Is this possible to do.

       

      Regards,

       

      Jon Ditchfield