topic Re: loadscript in condition in QlikView

loadscript in condition

Wed, 25 Nov 2020 16:16:04 GMT

Re: loadscript in condition

Anonymous — Thu, 08 Sep 2016 18:44:17 GMT

try this:

example attached also.

[ResultsTemp]:

LOAD wo,

quantity

resident WorkOrder;

left join

LOAD wo,

op_no,

op_def

Resident Routing;

right join

LOAD wo,

max(op_no) as op_no,

max(date) as date

Resident MalzDefteri

group by wo;

Results:

load wo,

quantity,

if(op_def='yy',date,null()) as date

Resident [ResultsTemp];

Re: loadscript in condition

Ricardo_Gerhard — Thu, 08 Sep 2016 18:50:23 GMT

Dear Kadir,

Could explain what you need or supply more details what is you issue?

Regards.

Re: loadscript in condition

Thu, 08 Sep 2016 19:09:13 GMT

Ricardo , thank you for your interest.

I have three tables. two tables together 'vlookup' I can connect with. but my need to get the greatest value in the other table record by the conditions in the two tables.

example :

work order take the value 1 table with table century 'op_def' worth of space 'century' from the record 'malz defteri' table to call the maximum date information. it 'load script' or 'calculated expression' with no harm being.

Sorry for bad english. I'm using translate

thank you so much