Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have two date columns in a table and our want QlikView to compare the two dates for each row but it is not doing correctly. my guess is that the two sets of dates are in a different format,so I tried converting both to a number using Num or converting both to Date but still having issues. Any ideas?
Date#() or TimeStamp#() both should work
So strange. neither worked.
Was that for me? or vishsaggi?
you. I was just saying neither timestamp# nor date# worked.
There are two options
1) Share a sample
2) Share screenshots to show how your LEADCREATEDATE and STAGEMODIFYDATE look when you load them without any manipulation.
LOAD *
FROM ....;
STAGEMODIFYDATE looks like this in raw form. here it is called modifydate
It seems that the MODIFYDATE seems to be read correctly and probably doesn't need Date#() function. The issue seems to be something else. Unfortunately, I don't think I have enough information to help you out here. It could be any thing and I am not sure how to get to the bottom of the issue
HI,
I tried this way and worked for me.
Below is my data.
Name | Date1 | Date2 |
A | 12/22/2016 | 11/22/2016 |
B | 12/23/2016 | 1/11/2017 |
C | 12/24/2016 | 1/12/2017 |
D | 12/25/2016 | 1/13/2017 |
E | 1/14/2017 | 12/25/2016 |
F | 1/15/2017 | 12/26/2016 |
LOAD Name,
Date1,
Date2
FROM
[..\dATES.xlsx]
(ooxml, embedded labels, table is Sheet1)
WHERE(Date1 > Date2);
After load it gave me only 3 rows.
I used Where clause next to transformation stage.(while loading from file.. Next , Next)
After reload I got 3 rows.
Thank you for all your help. I looked into this some more and discovered that the problem was driven by another part of my script. So I am OK. Thanks again.
I am glad you were able to locate your problem. I would suggest you to close this thread by either marking 'Assumed Answer' or posting what the actual issue was and then marking your own response as correct answer.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny