topic Re: Result comparion between 2 dates in QlikView

Result comparion between 2 dates

Wed, 09 Jul 2014 12:41:51 GMT

Hi,

I have the following two tables Joined in the datamodel and I need to show the comparison between data for two date selections.

Lets say the dates are start and end date.

Requirement: 1.Report all the records that had passed on 01/06/2014 but failed on 22/06/2014

2. Find all records that have failed on 22/06/2014 but were not present on 01/06/2014

How can we achieve this?

MK_QSL — Wed, 09 Jul 2014 12:47:48 GMT

it's possible.. provide sample data in excel format please.

Wed, 09 Jul 2014 13:17:46 GMT

Please find attached the xls

MK_QSL — Wed, 09 Jul 2014 21:21:24 GMT

may be i don't understand your question properly.. you can try below

=COUNT({<Result = {'PASS'}, DATE = {'01/06/2014'},KEY = P({1<Result = {'FAIL'},DATE = {'22/06/2014'}>}KEY)>}KEY)

and

=COUNT({<Result = {'FAIL'}, DATE = {'22/06/2014'},KEY = E({1<DATE = {'01/06/2014'}>}KEY)>}KEY)

Thu, 10 Jul 2014 07:02:46 GMT

That was brilliant mate Thanks a ton