Get distinct records for a date range using max/aggr

Mon, 24 Sep 2012 16:50:50 GMT

Hi,

I have a data set where I have QA test results for various tests executed multiple times. I want to provide search by start date and end date which gives me the latest results for each test (group by test_id). I am using this expression -

Count

(DISTINCT If(Aggr(NODISTINCT MaxString({1}start_time),test_suite_id) = start_time, test_suite_id))

This works fine to show my the correct numbers for the previous selections (for example if I have chosen a test group, date range, test environment etc.), however, it does not give me accurate results if I select the start time. Please see attached

Any help is appreciated!

Thanks,.

Shilpa

topic Get distinct records for a date range using max/aggr in QlikView

Get distinct records for a date range using max/aggr