Qlikview Script

[MauriceLudo]

Hi,

TABLE:

NoConcatenate

LOAD Distinct

*,

'1' as   [KPI],

KPI takes the value 1 can someone explain to me in which case we can make this choice

Best regards

Maurice

[petter]

It is very hard to tell without having the overview of the full load and the source table ...

Often such values are flags to indicate a specific condition for some rows. The flag can be used later in set expressions or If() expressions in the UI without calculating the more complex conditon (which was done in the load script) and it will speed up the application.