topic Delete record on Qlickview? in QlikView

Delete record on Qlickview?

Thu, 11 Mar 2010 16:08:41 GMT

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

Delete record on Qlickview?

Anonymous — Thu, 11 Mar 2010 16:14:09 GMT

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.

Delete record on Qlickview?

Thu, 11 Mar 2010 16:23:24 GMT

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

Delete record on Qlickview?

Anonymous — Thu, 11 Mar 2010 16:25:56 GMT

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

Delete record on Qlickview?

Thu, 11 Mar 2010 16:27:09 GMT

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

Delete record on Qlickview?

Thu, 11 Mar 2010 16:29:35 GMT

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

Delete record on Qlickview?

Thu, 11 Mar 2010 16:31:22 GMT

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, ...

Delete record on Qlickview?

Thu, 11 Mar 2010 16:44:06 GMT

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.

Delete record on Qlickview?

Thu, 11 Mar 2010 16:48:29 GMT

Hi Jope,

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

Best regards.

Delete record on Qlickview?

Thu, 11 Mar 2010 17:18:05 GMT

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.

Delete record on Qlickview?

Miguel_Angel_Baeyens — Thu, 11 Mar 2010 18:01:04 GMT

Hello,

You can do the following (as suggested by Anita and Mark)

1.- Load a table with all "EXP" keys you don't want to analyze in a map

NotToAnalyzeMap:MAPPING LOAD EXP, 1 AS DONT_LOADFROM OldQVTable

2.- Load from your database as follows

VerifiedInfo:LOAD Field1, Field2 WHERE ApplyMap('NotToAnalyzeMap', EXP, 0) = 0;SQL SELECT Field1, Field2 FROM Database;