Selection criteria

[#1]

Hello everyone,

I would like some help with the following. How would i go to have only Orders that contains all the selected conditions and filter out those who don't?

So from the example below i would like to see only the order with green border around?

Thank you in advance for your help.

[thomas_skariah]

Hi,

You can select the required Order number from Order column.

Sorry if i didn't got your point.

Regards,

Tom

[#3]

Hi

For this you can use the following Expression

if(Wildmatch(Condition,'Appointment Detail','Credit Profile','Net Price','Shot Product'),Order)

Also Suppress the Null values.

Regards

Rishi  Beri

[Anonymous]

Hi  dtringaqlink

                      u can use the following expression in d chart u want result

                   if(getfieldselection(CONDITION) = (' names goes here which u want ') , Order)

regards,

Vaibhav

[#5]

Thank you all for your helpful replies.

I have actually found a solution using this in the expression:

IF(Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME) ) = GetSelectedCount(CONDITION_NAME),Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME)))

[#6]

Thank you all for your helpful replies.

I have actually found a solution using this in the expression:

IF(Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME) ) = GetSelectedCount(CONDITION_NAME),Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME)))

[#7 · Accepted solution]

Thank you all for your helpful replies.

I have actually found a solution using this in the expression:

IF(Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME) ) = GetSelectedCount(CONDITION_NAME),Sum ( Aggr ( COUNT ( CONDITION_NAME ),ORDER_NO,CONDITION_NAME)))

actually this is even better

IF(Sum (TOTAL <ORDER_NO> Aggr ( COUNT ( CONDITION_NAME ),CONDITION_NAME,ORDER_NO) ) = GetSelectedCount(CONDITION_NAME),ORDER_NO)