load based on specific values of a field ? Any script available for Qlik Sense?

[#1]

Hi,

Just starting with Qlik and i would need to be able to load data from a system without datawarehouse.

I would like to load data based on a criteria (one value of the field).

So for instance, it could be :

transactions created after a specific date (based on a date field)

or

Transactions created by a specific team

Is there a way to avoid a full load of data?

Many thanks for your help!

Christophe

[marcus_sommer]

You could use a where-clause just like in SQL maybe something like:

...

where date(TransactionDate) >= date(today()-7);

- Marcus

[#3]

Hi Marcus, thanks for the help!

I add an example to make it clear for me :

LOAD NO,

    DT_OUV,

    RESS_H_NO_EMPL_RESPONSABLE,

    UNIT_ADM_CODE_TRAITE_PAR;

[DSSR_ADM]:

SELECT "NO",

    "DT_OUV",

    "RESS_H_NO_EMPL_RESPONSABLE",

    "UNIT_ADM_CODE_TRAITE_PAR"

FROM "INTIMM_PRD"."DSSR_ADM";

This is the script generated when I connect to the database. Let's say that instead of using a date field, I would need to retrieve the C060 code in the UNIT_ADM_CODE_TRAITE_PAR field.

When I add a where clause, it seems to affect the other part of the load script below.

Any suggestion ?

Many Thanks !

Christophe

[marcus_sommer]

Your used load-statement is called Preceding Load and where clause applied to the upper or the lower part will be effect the result in the same way. For filtering to the code you could use something like this:

where UNIT_ADM_CODE_TRAITE_PAR = 'C060';

- Marcus

[#5]

Many Thanks !