4 Replies Latest reply: Jan 31, 2013 4:27 AM by Alessandro Saccone RSS

    Help on expression

      Hi All,

       

      I have the below requirement in QlikView.

       

      Table:

       

      Valid Col1          Type             Key

      ---------------          -------             -------

      Category1         Custom1         12

      Category1         Category1       12

      Category1         Custom1         13

      Category1          -                    14

      Category2         Custom2         15

       

      Result:

       

      Valid Col1          Type             Key

      ---------------          -------             -------

      Category1         Custom1         13

      Category1          -                    14

      Category2         Custom2         15

       

       

      I would like to display the result, when Validcol1 <> Type (or) null, but also the Key should not be the same i.e.,the reason why the first 2 rows are not displayed in the result is because the 2nd row has Validcol1=Type and the key is 12, but eventhough the first row is not valid, the key is valid, hence don't want to display it in the result.

       

      Can someone, please help me with the expression for the above criteria. Thanks in advance.

       

      Thanks

      Sam