how to delete rows from a table

[hariishr]

hi,

assume there is a table regarding month wise sales data: col1 Month, Col2 Sales. (already loaded to Qlik Sense app)

data loaded Months are : Jan2019 to Dec2019

if i want to delete Jan2019, Feb2019 & Mar2019 how to do it.

i am not talking about using WHERE CLAUSE while loading data; just want to know is there options to delete data from existing table.

in SQL we can manipulate data;

//
delete from SalesTable

where Month in('Jan2019', 'Feb2019'. 'Mar2019');

//

[lironbaram · Accepted solution]

hi 

because once you start the reload in Qlik 

all table are emptied, if you'll use a where clause the result will be you deleted the rows  

[hariishr]

hi Lironbaram,

you mean to say reloading is the only option with filters. you can't delete from already loaded table.