Efficient Record Management in QlikView 12

[honekgo1]

Hello,

I am working with QV version 12.

To give you some context, I have 16 tables that are essentially the same but correspond to different years. I need to filter by a specific record, such as an 'id'. Each table contains between 6 and 12 million records, so loading all the records and then filt

[Oleg_Troyansky]

Hi there,

If these are database tables, then you certainly want to filter them on the database side, rather than bringing all of these records into QlikView and then filtering. You can pass your desired values to the database using a variable and a $-sign expansion, like this:

Set v_SelectedID = '12345';

LOAD

...

;

SQL SELECT * from MyTable 

WHERE ID = $(v_SelectedID)

;

Something along these lines. If your question was about something else, then please elaborate. You message appears unfinished...