topic Indirect set analysis in QlikView

Indirect set analysis

Anonymous — Tue, 13 Feb 2018 21:50:50 GMT

I am trying to create a report showing only those Cust Keys where Last Month the Add Indicator = Y OR the Type Code = 123 AND where This Month the Add Indicator = N OR the Type Code <>123 OR the Status = C

Any help?

I tried this - and yes, it failed......

only({<[Account] = P({1<[Date] = {'$(vLastMonth)'}

,[Add Indicator] = {'Y'}

>})

P({1<[Date] = {'$(vLastMonth)'}

,[Type Code] = {'123'}

>})

P({1<[Date] = {'$(vMaxDate)'}

,[Add Indicator] = {'N'}

>})

P({1<[Date] = {'$(vMaxDate)'}

,[Type Code] <> {'123'}

P({1<[Date]={'$(vMaxDate)'

,[Status]={'C'}

>})

>}[Cust Key]

)

Re: Indirect set analysis

swuehl — Tue, 13 Feb 2018 22:02:54 GMT

Hard to tell with no information about your model or expression context.

In addition, 'it failed' is not a good description of what you get compared to what you expected to get.

For now, I can't see how you've handled the AND part of your requirement, so maybe try using an intersection operator and few parenthesis:

only({<[Account] =

(

P({1<[Date] = {'$(vLastMonth)'}

,[Add Indicator] = {'Y'}

>})

P({1<[Date] = {'$(vLastMonth)'}

,[Type Code] = {'123'}

>})

)

(

P({1<[Date] = {'$(vMaxDate)'}

,[Add Indicator] = {'N'}

>})

P({1<[Date] = {'$(vMaxDate)'}

,[Type Code] <> {'123'}

P({1<[Date]={'$(vMaxDate)'

,[Status]={'C'}

>})

)

>}[Cust Key]

)

Re: Indirect set analysis

Anonymous — Tue, 13 Feb 2018 22:38:00 GMT

Thank you for the help, the

is what I needed!