Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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 .

1 Reply
Not applicable
Author

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