set analysis - union

Wed, 13 Jul 2011 10:45:34 GMT

Both the below expressions are working for me while trying to filter some records in a straight table.

only({<[StartDate]={"<=$(vStartDate)"}>}[bkgno]) * only({<[EndDate]={">=$(vStartDate)"}>}[bkgno])

only({<[StartDate]={"<=$(vEndDate)"}>}[bkgno]) * only({<[EndDate]={">=$(vEndDate)"}>}[bkgno])

I need to concatenate the results obtained through these two expression. I tried

(only({<[StartDate]={"<=$(vStartDate)"}>}[bkgno]) * only({<[EndDate]={">=$(vStartDate)"}>}[bkgno])) +

(only({<[StartDate]={"<=$(vEndDate)"}>}[bkgno]) * only({<[EndDate]={">=$(vEndDate)"}>}[bkgno]))

but it is not working, I am not getting results as expected.

Records with StartDate > vStartDate and those with EndDate < vEndDate is not getting displayed after using the union operator.

How to go forward for getting union of the above two separate results ?

Re: set analysis - union

Miguel_Angel_Baeyens — Wed, 13 Jul 2011 11:07:47 GMT

Hi,

If you mean you want to see those values that match both set modifiers, I'd try the following

(only({<[StartDate] = {"<=$(vStartDate)"} >} [bkgno]) * only({< [EndDate] = {">=$(vStartDate)"} >} [bkgno])) &
(only({<[StartDate] = {"<=$(vEndDate)"} >} [bkgno]) * only({< [EndDate] = {">=$(vEndDate)"} >} [bkgno]))

Using the "&" instead of the "+" to concatenate. Anyway it would be very helpful if you upload some sample data to see what you want to get.

Hope that helps

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

topic Re: set analysis - union in QlikView

set analysis - union

Re: set analysis - union