Set Analysis or ?

[Anonymous]

Hi,

I have aproblem and I hope you can help me ..

I am goingto make a report that shows ALL active orderlines plus orderlines ended in a specific(Selected)period.

The following fields are being used: ItemNo, Status, EndDate

Status canbe either Active or Ended. EndDate can be actual enddate OR if status = ActiveEndDate = Today

Does myquestion make any sence ?

[#2]

Hi,

please upload a short example *.qvw we can work with.

Thank you!

Rainer

[nstefaniuk]

Hi.

You can combine set analysis to do a OR in the set analysis clause. You can read the Help (search Set Analysis), some examples are provided.

[Anonymous]

Hi,

Here's an example.

What i would like is that if i select "jan" in month, item 1001 should appear since its still active.

So the result would be:

Item	Status	EndDate
1001	Active	08-02-2012
1003	Ended	31-01-2012

[swuehl · Accepted solution]

Maybe you could use something like

=only({<Status={Active},EndMonth=>+<EndMonth=EndMonth>} EndDate)

as additional expression (which could be hidden in presentation tab) in a straight table, if you select in EndMonth as your relevant period.

See also attached.

Stefan

[Anonymous]

Just what i needed.

Thanks a lot!!