Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Delete record on Qlickview?

Hello all,

Can someone explain me if exist any way to delete record after loading a Table.

On QV examples it's posible to delete records from an Excel Macro, but....

How can I done the same under QV Script?

Best regards

10 Replies
afuchten
Specialist
Specialist

Do you mean delete record from the source??

QlikView is meant for viewing (as the name already says) ...

Think the only way of achieving some deletion is by using Macro's.

Not applicable

Or did you mean deleting records from the loaded data in QV?

afuchten
Specialist
Specialist

In this case ... why loading the data if not needed??

Not applicable

I'm refereng to delete data on QV database.

Like on Call Center Demo

From Excel: DynamicUpdateCommand (SQL), but I want to do the same from QV Script (Not under Excel Macro)

Best regards

Not applicable

It's a question to know possibilities under the same system.

Not applicable

I'm with A Fuchten. Just don't load the data. When loading, exclude the data you don't want in the QV database (cloud). Use WHERE-clauses for instance. Or when joining tables, don't use OUTER JOIN, but LEFT, RIGHT or INNER JOIN, ...

Not applicable

Data is loaded on the system, and I have detected some mistakes on data.

I want to reload the new data (only data with mistakes corrected).

Then, I have to delete erroneous data and concatenate the new one.

Not applicable

Hi Jope,

How can you identify the erroneous records? Could you describe it?

Best regards.

Not applicable

After verify original database, there is a field with identificator.

Then I have a Key on old table 'EXP'

I want to del records on QV table with that EXP numbers and then concatenate the new ones.