2 Replies Latest reply: May 16, 2017 9:04 AM by kushal chawda RSS

    Counting orders with zero costs weekly

    Patrick Vos

      Hi all,

       

      I'am new to this site and qlikview.
      Bud i have the following question and i hope there is someone on line to help me:

       

      I have the following dimentions in qlikview:

      1 Timestamp_loaded (weekly upload orders)

      2 Order

      3 System_status

      4 TotCostAct

      I'am building a dashboard and i want to get the orders that are TECO (=System_status)  with zero costs weekly.

      Can any one help me with this?

       

      =count({$<System_status=('TECO'

       

      gr. Patrick Vos