How to link data from excel

[abc_18]

Hi,

I need to exclude some 'order number' in my dashboard report because they are causing duplicate records.

I am trying to store those order number in excel , so later if I want to remove from report I can easily delete from excel.

As app is in production, so can't change every time in Prod.

How can I achieve this, please suggest.

Thanks

[bramkn]

When you save the order numbers to be deleted in the Excel file. Everytime you reload it will discard these records.

When loading the order table put where not exists on the bottom.

[vvira1316]

May be you can use resident table an peek function to identify existing values...

I'm adding some example that are used for performance optimization but I feel it may help you...

Case1. Count( Distinct ‘FieldName’).

The distinct qualification, especially if text strings are read, is costly. A useful technique

is to assign the value ‘1’ to each new value as the field is read:

Load

Alfa,

if (peek('Alfa')=Alfa,0,1) as Flag1,

Num

resident table_1

order by Alfa Asc;

Here the “peek” compares the value of Alfa being read with that previously read. If the

values are the same “Flag” is set to 0, if they are different “Flag” is set to 1. The number

of distinct values will then be = sum(Flag). Please note that the list has to be ordered

and that when using “order by” in a load resident QlikView orders the list before starting

to read.

You can leverage flag to keep or remove records. I hope it helps.