4 Replies Latest reply: Sep 13, 2018 10:39 AM by omar bensalem RSS

    penalty for double transaction

    willem van der Plas


      I have a question about Qliksense. I would like to do the following. In our company, people buy items through an auction. Every time someone buys something, transaction costs are added and this is what I want to monitor. I want to be able to see who is doing double or triple transactions with the same product on the same day.

      I have already thought about this by looking at the article number and the purchase date. Every purchase is a row in the purchase table with a purchase date. (see appendix) and actually I want (through a flag or something) to give a penalty for every double purchase on the same date. Someone who knows how to do this?
      Thanks in advance!

      voorbeeld vraag.png

      Gr, Willem