Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Announcement: Certain actions are currently causing a Page Not Found error. This is a known issue and we are working with the platform vendor to investigate and resolve it.
Highlighted
spikenaylor1
New Contributor III

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