1 Reply Latest reply: Feb 19, 2013 2:31 PM by Donald Hutchins RSS

    Help! Set Analysis based of table created in QV

      Hey guys. Hopefully I can explain this correctly. Here goes:

       

      I'm creating a table for users to view. It's based on an expression, which does a count where one field is "standard60", one is "C", and one is "denial overturned".

       

      This expression works, and it creates the table, which is just a count where that criteria is met. The table is called "Favorable Claim Reconsiderations".

       

      I believe I have like, 180 records where all criteria is met (it's a "standard60", its a "C", and its a "denial overturned" record.)

       

      The issue I have is, I'm trying to take this table and it's data, and then find out, of those records, which of them had a letter sent out in a timely fashion.

       

      The expression is simple: =sum(apel_ltr_snt_dt) - sum([Received Date])

       

      How do I do this? Can I do the first expression, then "if these are met, then do the second expression" somehow?

       

      Hopefully I explained this correctly. PLEASE HELP!

       

      Thanks.

        • Re: Help! Set Analysis based of table created in QV

          When you say you are creating a table, do you mean you are creating a table in script, or that you are creating a straight table using expressions (i.e., just a chart)?

           

          It will help to clarify if you post the specifics, including the expression you've used.

           

          If you are using a chart and have set analysis to restrict what is counted in your expression, you can easily extend that to reference whether you have a date in some other field.  Without seeing your data model or expressions, I am having to guess a bit, but it could be as simple as:

           

          count({$<Criteria={'Standard60'}, SomeFld={'C'}, AnotherFld={'Denial'}, DateReceived={*"}> FldToCount)