Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Set Analysis or ?

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 ?

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

5 Replies
Not applicable
Author

Hi,

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

Thank you!

Rainer

nstefaniuk
Creator III
Creator III

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
Not applicable
Author

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:

ItemStatusEndDate
1001Active08-02-2012
1003Ended31-01-2012
swuehl
MVP
MVP

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
Not applicable
Author

Just what i needed.

Thanks a lot!!