topic Define in QlikView

Define

Fri, 22 Aug 2014 11:17:15 GMT

Hello,

I've this load statement with a field defined by an expression as follow:

LOAD

....

if(field_a='some_value' AND field_b='some_value', 1, 0) as new_field

This load statament fetch data from a QVD.

I need to add another condition like this:

AND field_c='some_value'

where field_c belongs to __another table__ (inside the DB this table is joined with the source table of the previous QVD).

This data will be showed in a graph and field to be defined is used as an expression.

I can insert the new condition inside the expression of the graph instead to put it in the field definition of the load statement?

In both cases how can I refer the field of the other table?

Therefore, due to the huge amount of record (several milion) how that table should be loaded?

Thanks in advance!

Re: Define

sujeetsingh — Fri, 22 Aug 2014 11:22:00 GMT

Some point i am not able to catch but yes try loading the table with this huge data and follow this document to make Optimized dashboards.

Best Practices for Data Modelling

Re: Define

Anonymous — Fri, 22 Aug 2014 11:26:27 GMT

Firstly join these two tables and then use resident load, in which you can put aal conditions.......

Re: Define

Fri, 22 Aug 2014 13:40:38 GMT

Thanks for your reply.

The pourpose is to define a field as an expression whose element belongs to different table.

I did something like the following:

QUALIFY "field_A1", "field_A2", "field_B1";

T1:

LOAD "field_ID",

"field_A1",

"field_A2",

FROM A.qvd (qvd);

inner join

T2:

LOAD

"field_ID",

"field_B1",

FROM B.qvd (qvd);

T3:

LOAD

"field_ID",

// some selection

T1.field_A1,

T1.field_A2,

T2.field_B1,

if((T1.field_A2)='test_value', 1, 0) As ZZZ // this is the field i try to define..

Resident T1

.. moreover the table T1 is very huge...

is this solution correct???