topic Dynamic search in set analysis in QlikView

Dynamic search in set analysis

Tue, 16 Dec 2014 01:41:41 GMT

I have the following calculated dimension:

=aggr(only({

< InvoiceID=P({<Payment={'$(vRule01)'}>} InvoiceID )>

< InvoiceID=P({<Payment={"=replace(Payment,'.',vRule02)"}> } InvoiceID )>

< InvoiceID=P({<[Purchase Type]={'$(vRule03)'}>} InvoiceID )>

<InvoiceID=P({<InvoiceID={"CreatedBy=ChangedBy"}>} InvoiceID)>

)

} InvoiceID) ,InvoiceID)

What I need to do here is to replace the hard-coded "ChangedBy" field in the last set analysis, with a variable such as vRule04, where depending on some other external events would pass the ChangedBy field or some other field (like ApprovedBy) to the set analysis.

Can someone provide the correct syntax.

Re: Dynamic search in set analysis

rwunderlich — Tue, 16 Dec 2014 02:28:47 GMT

I think it would be

CreatedBy=$(vRule04)

Have you tried that?

-Rob

Re: Dynamic search in set analysis

Tue, 16 Dec 2014 05:19:48 GMT

Had tried it before posting this with no success. Tried it again after your suggestion and now it works!. Thanks for your response and time.