Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Paula1
Creator
Creator

How to change date to date x of this do not sign

Brun Pierre, helped me with this script. But failed to change date to datax
 
cod date datex Status id qtde
2360 11/12/2012 17:33 15/12/2012 17:33 -1 201221 -24
2360 11/12/2012 17:33 15/12/2012 17:33 -1 201222 -84
2360 11/12/2013 17:38 15/12/2013 17:38 -1 201228 -24
2360 11/12/2013 17:38 15/12/2013 17:38 -1 201227 -84
 
How do I change date to datax in this script that is correct.
 
Desired result.
cod date datex Status id qtde
2360 12/11/2012 17:33 15/12/2012 17:33 -1 201221 -24
2360 12/11/2012 17:33 15/12/2012 17:33 -1 201222 -84
2360 12/11/2013 17:38 15/12/2013 17:38 -1 201228 -24
2360 12/11/2013 17:38 15/12/2013 17:38 -1 201227 -84
2360 15/12/2012 17:33 15/12/2012 17:33 0 201221 24
2360 15/12/2012 17:33 15/12/2012 17:33 0 201222 84
2360 15/12/2013 17:38 15/12/2013 17:38 0 201228 24
2360 15/12/2013 17:38 15/12/2013 17:38 0 201227 84

 

Correct script just need to handle date to datax
Data:
LOAD id, 
     date, 
datex,
     status, 
     ordem, 
     qtde
FROM SourceTable;

Positives:
LOAD id, 
     date, 
     datex,
     not Sign(status) as status, 
     ordem,  
     Fabs(qtde) as qtde

Resident Data
Where status = -1;
Paula Santos
vitória - ES
Labels (2)
2 Solutions

Accepted Solutions
BrunPierre
Partner - Master II
Partner - Master II

Positives:
LOAD cod,
date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde

Resident Data
Where Status = -1;

BrunPierre_1-1684070197247.png

View solution in original post

3 Replies
BrunPierre
Partner - Master II
Partner - Master II

Positives:
LOAD cod,
date,
datex as date,
datex,
not Sign(Status) as Status,
id,
Fabs(qtde) as qtde

Resident Data
Where Status = -1;

BrunPierre_1-1684070197247.png

Paula1
Creator
Creator
Author

thanks
Paula Santos
vitória - ES