1 Reply Latest reply: May 22, 2011 5:59 AM by Deepak Vadithala RSS

    New to QlikView (Not even a baby) - How to do selection with "OR"  condition

      All,

      I am very new to QlikView . We are in the process of evaluating QV. I have downloaded the personal edition and was playing with it showing demos to our executives and so forth.

       

      Once key thing came up in our discussion was doing an "OR" selection between two fileds.

       

       

      EX.  If I want to see orders were “created on 1/1/2011”  OR “Product_Code = 10002”

       

      By default (according to my very little understanding withQV) if I select two fields they are being joined using “AND”  and theabove selection will retrieve all the order for 10002 on 1/1/2011.

       

      Another example.

      If I want to see orders that were generated for“Product_Code = 10002” on 1/1/2011  also for “Product_Code = 80009” on 4/1/2010

       

      (Product_Code = 10002  AND ORD_DT = 1/1/2011")   OR   (Product_Code = 80009   AND ORD_DT = 4/1/2010)

       

      is this possible?

       

      Thanks,

      AP

        • Re: New to QlikView (Not even a baby) - How to do selection with "OR"  condition
          Deepak Vadithala

          AP,

           

          3 Months back, I was in your shoes...evaluating QV. Anyway here is the information...

           

          A multiple selection within a list box is usually interpreted as logical "OR", meaning that data entries associated with any of the selected values will be shown. However, under certain circumstances it can be set to be interpreted as "AND", implying that QlikView must find the solutions that are associated to all the selected field values, not just to any of them.

           

          The mode for the field is set in the list box dialog (Object menu >> Properties >> General >> And mode).

           

          A value in a list box in "And" mode will be marked with an ampersand "&" when selected.

           

          And-Tables :

          A field cannot always be set to logical and mode. The reason for this is that the and alternative is logically meaningful only if the concerned field is

          linked to only one other field. The following criteria must be fulfilled:

           

                    • the field must only exist in one logical table,

                    • the field must be the second column, and

                    • the field must be distinct.

           

          Also you should explore "Set Analysis" features. With Set Analysis the possibilities are endless... I mean you can do pretty much everything . I am also attaching a simple presentation on Set Analysis for your consumption.

           

          Do let me know if you need further help.

           

          Good luck!

           

          Cheers - DV