Hi,
I have a table in postgres db which has to be incrementally loaded to qlik and stored to QVD. The problem is that table only has an ID field as primary key, and no timestamps. Records can be i...
Hi I need to compare 2 file eg FILE A Sr no Product 1 P1 2 p2 3 p3 and FILE AB Sr no Product 1 P1 2 p4 3 p5 in this i wanted know product exists in both the table pls guide me how i c...
There are 2 qvd files (QF1,QF2), both with ID field as primary key. I want to know how many ID values are in: > QF1 that are not in QF2 (QF1 - QF2) > QF1 and QF2 (QF1 ^ QF2) &g...
How will I be able to get values from a qvd file which are not available when compared to other qvd. For example I have Contract Account and Document Number in a qvd file (qvd1). I want to get all t...
hi All, I have 2 qvd files. Say QVD1 and QVD2 both have similar no of fields. I want to check if they are having same data or not.. Do we have any operation for it.. like minus in S...
Hi guys.
I know this will turn out to be nonsense but...
I having problems comparing 2 dates values.
First, we have a Variable defined like this:
Let vToday = Today();
Then, we're trying t...
Hi, I have multiple QVD's that I need to concatenate t o make one fact table, I want to Optimization to work when reloading the Document but at the moment it doesn't work due to the field d...
Hi, Is there a technique to use set analysis to compare dates - loaded from QVD files? I load the QVD data using the following script: LOAD filename() as FileName, date(date#(mid(f...
...bsp; I am trying to compare todays date with the save time of the QVD, if the date matches then output YES otherwise output NO. It seems to output NO even though the dates match (as seen below.....
Hi all, I have to compare the headers of two QVD files. For example, if my QVD1 has orderID and Description, I have to check if my another QVD has the same orderID and Description. Set a = 'C:\U...