3 Replies Latest reply: Jan 3, 2018 12:58 PM by Jose Persichini RSS

    Divide values with column null

    Jose Persichini

      I have a table with the expenses of truck drivers. One of the columns of this table, is the "driver_id".

       

      Sometimes, the "driver_id" is null because of the expense is not imputable to any driver. I want to get all of the expenses with driver_id null and divide that value into all of the drivers. How can I do it in Qlik Sense?

       

      For example:

       

      $500 of expenses with driver_id null. Then if I have 5 drivers, I want to put $500/5 = $100 to each driver and show it, for example, in a pivot table.