Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Carlaf_93
Creator II
Creator II

Script problem

Good morning,

i have a problem with my script.

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);
join
load
AGECCODICE, 
[AGECDIVISION]
Resident ag;

drop table ag;

I would like to put an if condition on AGECDIVISION about the data field...

It doesn't works because Qlikdoesn't understand that data is in the same table...

Any ideas?

1 Reply
Anil_Babu_Samineni

I didn't understand some thing here? Why can't you create another field with in table?

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]

If(....) as DateField
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);

If that is not possible during QVD loads you can try this way

[ag]:
LOAD
AGECCODICE 
[AGECDIVISION]
from (qvd);

[BASE]:
Load

 [Codice_Agente],
[COD_ART],
[DATA] ,
[value]

From 2 (qvd);

Final:

NoConcantenate
load
AGECCODICE, 
[AGECDIVISION]
Resident ag;

drop table ag;

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)