3 Replies Latest reply: Sep 9, 2013 8:09 AM by Marcus Sommer RSS

    How to calculate overall score

    Venkatesh Mohta

      Hi,

       

      I am new to qlikview and working on a project to get overall score for a quality project. I have two sets of data - Actual data and exception data. If we have multiple tables, how can we get the distinct count of records in each table separately.

       

      We are trying to use the below but not sure how to use distinct in this or if there is a better way to get the required results

       

      sum

       

      ({$<$Table={'Main Dataset'}, $Field={'sec_acct_rec_id_1'}>} $Rows)