4 Replies Latest reply: Sep 13, 2011 5:54 PM by sandeepa rout RSS

    Filter the values

    sandeepa rout

      Hi All,

       

      I am Using Qlikview10.

       

      Please refer the following table:

       

       

      M.Contacts
      D.Contacts
      M.Account
      D.Account
      112323
      2-25-
      3327-
      443030
      5-35-
      6640-
      7745-
      885050
      9---
      1010--
      11---
      12---
      13---

       

       

      I want this table should view as following:

       

       

      M.ContactsD.ContactsM.AccountsD.Accounts
      9---
      1010--
      11---
      12---
      13--

       

      It means I want to see the records where the M.Accounts and D.Accounts are Null against the Contacts.

      How to Filter it?

       

       

      Thanks,

      Sandeepa

        • Re: Filter the values

          Hi

          i sugges to use a straight table like in the attached example

           

          Regards

          Gilles

          • Re: Filter the values
            Sunil Chauhan

            see the attacheed filee

             

             

            but i hope you need to do like below

             

            Tab:
            load * inline [
            M.Contacts,D.Contacts,M.Account,D.Account
            1, 1 ,23, 23
            2, -, 25, -
            3, 3 ,27 ,-
            4 ,4 ,30, 30
            5 ,-, 35, -
            6 ,6 ,40, -
            7 ,7 ,45 ,-
            8 ,8 ,50, 50
            9 ,- ,- ,-
            10 ,10, - ,-
            11 ,-, -, -
            12, - ,-, -
            13 ,-, - ,-
            ];

            load * ,
            1 as junk
            resident Tab where isnull(M.Account)=-1 and isnull(D.Account)=-1;

            drop table Tab;


            or
            Tab:
            load * inline [
            M.Contacts,D.Contacts,M.Account,D.Account
            1, 1 ,23, 23
            2, -, 25, -
            3, 3 ,27 ,-
            4 ,4 ,30, 30
            5 ,-, 35, -
            6 ,6 ,40, -
            7 ,7 ,45 ,-
            8 ,8 ,50, 50
            9 ,- ,- ,-
            10 ,10, - ,-
            11 ,-, -, -
            12, - ,-, -
            13 ,-, - ,-
            ];

            load * ,
            1 as junk
            resident Tab where isnull(M.Account) and isnull(D.Account);

            drop table Tab;

            or
            Tab:
            load * inline [
            M.Contacts,D.Contacts,M.Account,D.Account
            1, 1 ,23, 23
            2, -, 25, -
            3, 3 ,27 ,-
            4 ,4 ,30, 30
            5 ,-, 35, -
            6 ,6 ,40, -
            7 ,7 ,45 ,-
            8 ,8 ,50, 50
            9 ,- ,- ,-
            10 ,10, - ,-
            11 ,-, -, -
            12, - ,-, -
            13 ,-, - ,-
            ];

            load * ,
            1 as junk
            resident Tab where len(M.Account)=0 and len(D.Account)=0;

            drop table Tab;