Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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