topic Selection criteria in QlikView

Selection criteria

Tue, 30 Oct 2012 16:05:50 GMT

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.

Re: Selection criteria

thomas_skariah — Wed, 31 Oct 2012 02:31:41 GMT

Hi,

You can select the required Order number from Order column.

Sorry if i didn't got your point.

Regards,

Tom

Re: Selection criteria

Wed, 31 Oct 2012 04:55:33 GMT

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

Re: Selection criteria

Anonymous — Wed, 31 Oct 2012 06:30:18 GMT

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

Re: Selection criteria

Wed, 31 Oct 2012 12:37:48 GMT

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)))

Re: Selection criteria

Wed, 31 Oct 2012 12:38:21 GMT

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)))

Re: Selection criteria

Wed, 31 Oct 2012 12:39:50 GMT

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)