Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

New Contributor

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

2 Replies
Esteemed Contributor

Re: Count shops once


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.

Honored Contributor II

Re: Count shops once

to count every shop only once:

Count( DISTINCT unique_shop_number_field )