Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Here is the qvf. Hope this is what you want.
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
Hi,
Try this expression in your Table and Bar chart
COUNT({<Product = {$(=CONCAT(DISTINCT Product,',',Product))}>}[Transaction#])
Let us know if it helps.
I think this is the right solution:
Use this as the measure ..Sum(AGGR(If(Count({<Product={A}>}Product)>1,Count(Distinct City)), City))