Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Margaret
Contributor II

set analysis - defining set with multiple criteria for analysis

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'}>}

1 Solution

Accepted Solutions

Re: set analysis - defining set with multiple criteria for analysis

May be this:

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

                Document_8_4 = {'Y'},

                Betw_8_4 = {'Y'},

                Conf_Rec_Date = {'Y'},

                Betw_8_midn = {'Y'}

>} OmOrdID)

View solution in original post

2 Replies

Re: set analysis - defining set with multiple criteria for analysis

May be this:

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

                Document_8_4 = {'Y'},

                Betw_8_4 = {'Y'},

                Conf_Rec_Date = {'Y'},

                Betw_8_midn = {'Y'}

>} OmOrdID)

View solution in original post

Margaret
Contributor II

Re: set analysis - defining set with multiple criteria for analysis

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