I am working on a data qulaity project and I need to calculate the % of good data based on a calculated dimension, Data Element and the rules linked to the data element for different dimension.The data for calculated dimension and data element is in one table and the rules related data is in another table which is linked by Data Element.
The result which I am looking for is to reflect the below:
If I select a particular data element it should check if there are rules for different dimension and if the result is =0 then it should show 0% and if rules<=0 and if there are no exceptions then show 100% and if there are exception for the rule then show the result based on the exception.
I have tried using the below expression for the different dimension but I does not give me the correct data:
If (DQ_Dimension='Accuracy',1-TextCount(DISTINCTsec_acct_hldg_id)/sum({$<$Table={'Main Dataset'}, $Field={'sec_acct_rec_id'}>} $Rows) ,if (DQ_Dimension1='Accuracy ' and sum(Rule)=0,0,1)).
Can someone let me know as to how can this be done in qlikview
