4 Replies Latest reply: Apr 25, 2016 5:19 AM by Sam Gamble RSS

    Can I create an exception report that shows clients on which we have more than less than 20% margin and more than $100,000 of revenue?

    Sam Gamble

      Client Name

      RevenueMargin $

      Margin

      %

      Revenue change

      over last period

      A100404020
      B503060-10
      C7030385
      D20010540
      E150151530
      F20630-2
      G104406
      H40102540

       

       

      Exception Condition = Show All Clients over X revenue and  Margin less than Y %

       

      Hi if I have the data above in qlik sense and I want to create an exception report where the user can specify the exception condition on the front end... can I do this

      Eg the end user would go in and switch X to 100 and y to 30 - the data set would return D and E

       

      Is this possible?

       

      Thanks.