Discussion Board for collaboration related to Creating Analytics for QlikView.
I'd like to use weighting/proportions in set analysis with the P() function to weight the variable used in the possible function.
EXPRESSION - Readmit Rate % for all patients, per coverage selections:
For example, based on my selections, let's say that the distribution of Coverage Type is the following:
Current Selections Coverage Type Distribution:
The P() works to exclude D from the calculation - however, what if I want to weight/use proportions based on the total?
Total Coverage Type Distribution:
Proportion based on Current Selections/Total:
Is there any way to account for these proportions in the expression?
I am not entirely sure I get, but may be you need this