
Contributor
2018-02-05
05:33 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Count shops once
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
467 Views
2 Replies

Champion
2018-02-05
05:57 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
Can you elaborate more or try to modify your questions ?
try to describe your problem including some (random) data which represents real data and show the desired output.
413 Views


Partner - Champion
2018-02-05
06:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
to count every shop only once:
Count( DISTINCT unique_shop_number_field )
413 Views
