1 Reply Latest reply: Sep 30, 2014 5:08 AM by Alexandru Ana RSS

    How to exclude a specific value or values from a column from script Qlikview?

      I can do this liek table  with all column,values and then list box that column and select the 2 values and left click exclude and will show what i want in table .

      How to make this in script :

       

      Select  * from  table

       

      Where Type not in(261,261)

       

       

      Second  thing i need is :

       

      after i get the result is where i get 2 same entries or more for a value of column 3 lets say to show only one value and some up the values from column 4 for those entries that had same value in column 3 .

        • Re: How to exclude a specific value or values from a column from script Qlikview?

          I used this and it shows all but excluded  and sum  like i want :

           

          Sum({<TMş=-{261,262}>} Cantitate) that gives me this:

           

           

           

           

          The problem is that i need to have a final table that should show:   So i need to get the excluded one to show in the final report as it tied like the excluded one is iron  and has the register code ,from iron i made doors ,car part that have registry code in system also ...

           

          Comanda PPLot MPData transariiMaterie PrimaLot PTPiesa transata
          1050059554416/5/20141000403554412000050
          2000131
          554412000199
          9200003