Count shops once

[jespermiles]

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

[YoussefBelloum]

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.

[agigliotti]

to count every shop only once:

Count( DISTINCT unique_shop_number_field )