topic calling orderdate into 2nd table from first table in QlikView

calling orderdate into 2nd table from first table

harleen_singh — Wed, 24 Aug 2011 08:07:10 GMT

Hello,

i am writing this code

Load

orderdate, A, B,C from table1

Load

if(IsNull(EndDate),max(orderdate),EndDate) as EndDate,

StartDate,

TerritoryID From

Table2

the above code gives error?? how to solve it?

thanks
Lavi

Re: calling orderdate into 2nd table from first table

Wed, 24 Aug 2011 08:18:51 GMT

Hello lavi,

i think you have to map the orderdate in table2

than you can write:

Load

if(IsNull(EndDate),max(orderdate),EndDate) as EndDate,

Load

(mapping orderdate) ,

EndDate,

StartDate,

TerritoryID

From

Table2

calling orderdate into 2nd table from first table

harleen_singh — Wed, 24 Aug 2011 08:38:51 GMT

Lukasarn,

thanks for response,

but u have loaded this statement

if(IsNull(EndDate),max(orderdate),EndDate) as EndDate

in first table. but i am loading this statement in second table.

and also

Load (mapping orderdate) format is not correct i guess Mapping Load is correct.

thanks
Lavi

Re: calling orderdate into 2nd table from first table

Wed, 24 Aug 2011 08:47:57 GMT

Do the tables have a relation?

table1:

Load

orderdate,

from

table1;

Mappingtable:

Mapping Load ......

table2:

Load

if(IsNull(EndDate),max(orderdate),EndDate) as EndDate,

Load

apply map .... ,

EndDate,

StartDate,

TerritoryID

From

Table2

of course (mapping orderdate) is not the right syntax ,it should only show you where you have to write it.

calling orderdate into 2nd table from first table

SunilChauhan — Wed, 24 Aug 2011 08:48:23 GMT

hello sardar ji,

post a clear requirement what u want

calling orderdate into 2nd table from first table

harleen_singh — Wed, 24 Aug 2011 09:14:08 GMT

lukasarn

no table does not have any relation.

and what to write after apply map .... , in your answer??

thanks

Lavi

calling orderdate into 2nd table from first table

harleen_singh — Wed, 24 Aug 2011 09:29:14 GMT

lukasarn,

can i store max(orderdate) in variable and then use it on other table??

thanks
Lavi

calling orderdate into 2nd table from first table

SunilChauhan — Wed, 24 Aug 2011 09:51:56 GMT

hello lavi ,

now u are on right track u can store it into variable and use anywhere u want .

calling orderdate into 2nd table from first table

its_anandrjs — Wed, 24 Aug 2011 09:57:42 GMT

Hi,

Yes you are able to put Max(orderdate) in variable like vOrderVar = Max(orderdate) and where ever you use in the application you are able to use it.

Regards

Anand

calling orderdate into 2nd table from first table

kaushiknsolanki — Wed, 24 Aug 2011 10:06:05 GMT

Hi,

Try this.

Table1:

Load

orderdate, A, B,C

from table1;

Temp:

Load Max(orderdate) as Max

Resident Table1;

Let vMax = peek('Max',0,'Temp');

Drop table Temp;

Table2:

Load

if(IsNull(EndDate),$(vMax),EndDate) as EndDate,

StartDate,

TerritoryID

From Table2

Regards,

Kaushik Solanki

calling orderdate into 2nd table from first table

harleen_singh — Wed, 24 Aug 2011 10:06:21 GMT

Lukasarn,

i have done by creating Temporary table

Temp:

LOAD

num(max(OrderDate)) as MaxDate

Resident Table1;

LET vMaxDate = peek('MaxDate', 0, 'TEMP');

Drop Table Temp;

Now i can use this variable VMaxDate any where.

thanks for your kind help

Regards
Lavi