Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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');
//
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
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
hi Lironbaram,
you mean to say reloading is the only option with filters. you can't delete from already loaded table.