2 Replies Latest reply: Feb 5, 2018 6:03 AM by Andrea Gigliotti RSS

    Count shops once

    Jesper Miles

      Hello everyone

       

      I have a problem, which I hope one of you can help me solve.

       

      The company runs sales forces on behalf of our costumer. The sales force employees visit the same store each mount an report sales back to me via an app, I than upload these results to a qlik sense dashboard where my costumer can monitor the sales.

      • One of the questions in the app is a Yes or No, how can I do a count that newest result from everyshop? (I only wanna count everyshop once, although we revisit 12 times a year )
      • Furthermore is it then possible to count everyshop(once) and if it has a “Yes”?

       

      Every shop has a unique shop number

       

      Best regards

      Jesper Miles

      RelationMedia Denmark