topic Re: set analysis - defining set with multiple criteria for analysis in QlikView

set analysis - defining set with multiple criteria for analysis

Margaret — Mon, 26 Sep 2016 21:38:52 GMT

How do I write set analysis to count OmOrdID's where all of the following conditions apply?

{$<OmOrdID = {"=DocumentDate = AuditDate2"}>}

{<Document_8_4 = {'Y'}>}

{<Betw_8_4 = {'Y'}>}

{<Conf_Rec_Date = {'Y'}>}

{<Betw_8_midn = {'Y'}>}

sunny_talwar — Mon, 26 Sep 2016 21:40:21 GMT

May be this:

Count({$<OmOrdID = {"=DocumentDate = AuditDate2"},

Document_8_4 = {'Y'},

Betw_8_4 = {'Y'},

Conf_Rec_Date = {'Y'},

Betw_8_midn = {'Y'}

>} OmOrdID)

Margaret — Mon, 26 Sep 2016 22:00:43 GMT

Thank you!!!!!!!!!!!!!!!!!!1