Filter Data while loading

[pkpandey]

How to filter data while loading a qvd without using where clause. For example I have a field named state and I want to load data only for "ORISSA" without using where clause. How will I do that?

[agomes1971 · Accepted solution]

Hi,

please see this

How to filter a data from qvd with optimized load? | Qlik Community

HTH

André Gomes

[Anonymous]

Try like this?

Load

*,

if(State='ORISSA', State) as State

From YourQVD;