topic Re: Question to solve duplicate medical codes problem in App Development

Question to solve duplicate medical codes problem

SivanVigder — Fri, 02 Apr 2021 08:20:50 GMT

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

Re: Question to solve duplicate medical codes problem

kaushiknsolanki — Wed, 26 Feb 2020 07:57:37 GMT

Hi,

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

Re: Question to solve duplicate medical codes problem

SivanVigder — Wed, 26 Feb 2020 12:00:30 GMT

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

Re: Question to solve duplicate medical codes problem

Gabriel — Wed, 26 Feb 2020 12:19:55 GMT

Hi,

Try this expression in your Table and Bar chart

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

Let us know if it helps.

Re: Question to solve duplicate medical codes problem

Lisa_P — Wed, 26 Feb 2020 23:49:42 GMT

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