topic Re: How to exclude a specific value or values from a column from script Qlikview? in QlikView

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

Tue, 30 Sep 2014 08:18:21 GMT

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?

Tue, 30 Sep 2014 09:08:13 GMT

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 PP	Lot MP	Data transarii	Materie Prima	Lot PT	Piesa transata
1050059	55441	6/5/2014	1000403	55441	2000050
					2000131
				55441	2000199
					9200003