10 Replies Latest reply: Nov 28, 2015 2:48 AM by neil rodrigues RSS

    Set analysis filter a dimension

    neil rodrigues

      hi I need a bit of help. I am trying to analyse a large dataset to see what clients/customers are driving "losses" .... as such I should be able to select the "n" clients who have a profit <0

       

      this is the set expression I wrote. it doesn't seem to work in Qliksense and I cant apply a filter too... any help would be appreciated. thank you

       

      sum({$<CLIENT={"$(=aggr(sum(PROFIT),CLIENT)<0)"}>} PROFIT)