Question to solve duplicate medical codes problem

[SivanVigder]

I have a database of medical codes that I need to check when certain codes were applied twice per patient, or twice per appointment, where they were only supposed to be once per app.

I want to add charts and tables to a dashboard to show that, but I want to do it on the frontend .

I am looking for help with the formula I can use for this kind of data structure 

To make it easy for all, I change it to products sold in countries and cities. but it is the same idea.

Please help ... 

https://docs.google.com/spreadsheets/d/1V0gh_eYOA9wJvelIXKOA4JEJourj3fCESnbDNZs4tJ8/edit?usp=sharing

email me sivanvigder@gmail.com 

[kaushiknsolanki]

Hi,

Here is the qvf. Hope this is what you want.

[SivanVigder]

Thank you so much 

is there a chance you wrote the formulas 

I am using qlik sense remotely and don’t know how to load qvf files there .

i simply create dashboard and use formulas in the front end . 

thabks again, and I hope you can help 

[Gabriel]

Hi,

Try this expression in your Table and Bar chart

COUNT({<Product = {$(=CONCAT(DISTINCT Product,',',Product))}>}[Transaction#])

Let us know if it helps.

[Lisa_P]

I think this is the right solution:
Use this as the measure ..Sum(AGGR(If(Count({<Product={A}>}Product)>1,Count(Distinct City)), City))