Selection Across Fields (not in expression or script)

[robert99]

I'm sure there is a simple way to do this but I can not get it to work

And I know it is possible to either (which I have done until now)

Set this up in an expression (as say  sum (if (OrderDate>DueDate etc)  or set up in script as a selectable / clickable field

But what I would like to do to make a selection as (to appear in the current selection box)

OrderDate > DueDate

I have not been able to get this to work

Thanks for any help

[sujeetsingh]

Did not get you can you please explain in detail or provide sample .

[#3]

In script write the expression as

sum (if (OrderDate>DueDate etc)) as Selection

and take the 'Selection' field in in list box.

So whenever u will select the list box it will also display the value in current selection box.

Hope this will help you..!

[robert99]

I have an OrderDate field and a DueOrder field (for an order)

These are in separate fields

I can set up an expression in  a chart       Count (if (OrderDate > DueDate) OrderNumber  

to list these

But I would sooner just make a selection as required. So all charts and tables would be filtered by this selection

Thanks

[MK_QSL · Accepted solution]

In your script add like below...

IF(OrderDate > DueDate, 1, 0) as SelectionFlag

Now you can use this flag to count number of orders having OrderDate > DueDate

COUNT({<Flag = {1}>}Distinct OrderID)

Hope this helps..

[robert99]

Thanks

I could do this but I don't want to include this in script if possible. Or in an expression

[#7]

So do u want to display 1 listbox where u want to display Order Number where

OrderDate > DueDate condition is satisfied.

and based on this order nuber selections u want to filter the data??

Correct if my understanding is wrong..

[robert99]

Thanks

The reason why I do not want to do this (this time) in script is because the fields are in different unjoined tables. I know I can join tables or use mapping etc but already the script ahs become messy

I'm just trying to tidy up the script and reduce my script if possible. This would be one way to do it

[MK_QSL]

In this case, your sample apps or data file would be helpful to give you quick answer..

[robert99]

I'm off to work and will explain more when I arrive if required

But what I want is simple (yet I can not see how it is done) that I do not seem to be explaining it that well

If I have

Order Number   Order date          DueDate

123                  1/1/2014               1/1/2014

124                    2/1/2014               10/1/2014

125                     2/1/2014               1/1/2014

I can easily select say all Orderdate = 2/1/2014

But what I want to select (without using script or an expression) is

Orders where OrderDate>DueDate

I appreciate your help as I've tried to do this in the past but have not been able to (so have used an expression or script)