6 Replies Latest reply: Oct 31, 2012 10:25 AM by dtringaqlink RSS

    Selection criteria

      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.

       

      QlikViewSelection.JPG

        • Re: Selection criteria
          Thomas Skariah

          Hi,

           

          You can select the required Order number from Order column.

          Sorry if i didn't got your point.

           

          Regards,

          Tom

          • Re: Selection criteria

            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

            • Re: Selection criteria
              - -

              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

                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

                  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

                    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)