Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spikenaylor1
Creator
Creator

Some Help required with duplicate value causing error in formula

My database is for documents Right first time (RFT)

the query produces data which is pulled into QlikView

I have a situation where the document can be classified as RFT if the only issue with the document is  a query relating to parts of the doc.

so the query produces the following result,

two or more records for a document that have a RFT of True

in my QlikView dashboard

we need to see these two records of querys, but we only need to count up one of them as RFT

 

this is where I am coming unstuck

 

my formula for calculation of the RFT is:

Sum(RFT)/count(Distinct ID)

This works upto the point of where I get two records which are RFT (True) but containing Querys.

so I get a sum of 2 for these two records when in fact it should only be a sum of 1

I think I need to sum up the RFT for Distinct ID, but not sure of the formula for this

 

any help please

many thanks for looking

 

 

0 Replies