Solved: Compare data from two files - Qlik Community

ashmitp869 · ‎2021-05-10

Hi there,

How to find the data percentage matching from the below dataset.

The fields are [049Episode.VISIT_ID] with EP.Stay Number

Will the formula work to see how many percentage data is present

Count([049Episode.VISIT_ID])/Count([EP.Stay Number])

Dalton_Ruer · ‎2021-05-11

Without worrying about whether your second file has a bunch of stay numbers that might not be in your first file, and without worrying about whether you have multiple rows for a stay/visit, then yes your formula would yield the percentage of stay numbers that have a visit id associated. 2/13

I always advise creating a quick sanity check with just the numerator and just the denominator as KPI's to check if any of the things I said "I won't worry about" are things YOU do need to worry about. If you find that the numbers don't match what you expect, you may need Count(DISTINCT or you may need to change how you load your second table to use a WHERE EXIST ([EP.Stay Number]) so that it only loads visits for stays you already have loaded.

View solution in original post

Dalton_Ruer · ‎2021-05-11

Without worrying about whether your second file has a bunch of stay numbers that might not be in your first file, and without worrying about whether you have multiple rows for a stay/visit, then yes your formula would yield the percentage of stay numbers that have a visit id associated. 2/13

I always advise creating a quick sanity check with just the numerator and just the denominator as KPI's to check if any of the things I said "I won't worry about" are things YOU do need to worry about. If you find that the numbers don't match what you expect, you may need Count(DISTINCT or you may need to change how you load your second table to use a WHERE EXIST ([EP.Stay Number]) so that it only loads visits for stays you already have loaded.