Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to like separate count newly and added data.. and total how many lines are newly and changed data incremental load perform..
For historical and added records, you can use the NoOfRows() function twice (after the increment and after the historical addition or vice versa).
An incremental load can take care of replacing changed records, but since the implementation is entirely up to you, it would be difficult if not impossible to suggest a generic solution.
Care to provide a few more details about how exactly your incremental load is executed?
Best,
Peter
Hi,
You can add some kind of flag in your script to count the new records like below
Data:
SELECT
*,
1 AS NewData
FROM Data
WHERE Date = Trunc(SYSDATE - 1);
Concatenate(Data)
LOAD
*
FROM Data.qvd (qvd);
Now you can use Sum(NewData) to get the count of new records.
Hope this helps you.
Regards,
Jagan.
Is there any possible using text Box with expression.
Hi,
Try the above script and use below expression in the Text oject
='Newly added rows = ' & Sum(NewData)
Hope this helps you.
Regards,
Jagan.
My Script Like this.. will say for this any solution for this query..
let vLMD=Now();
Incr:
LOAD EMPID,
NAME,
VALUE,
LMD
FROM
D:\Qlikview\excel\incri.xlsx
(ooxml, embedded labels, table is Sheet1)
Where LMD > '$(vvLMD)';
Concatenate
LOAD EMPID,
NAME,
VALUE,
LMD
FROM
D:\Qlikview\Practies\Incr.qvd
(qvd)
Where not Exists (EMPID,EMPID);
vvLMD=VLMD;
STORE Incr into Incr.qvd;
Hi,
Try like this
let vLMD=Now();
Incr:
LOAD EMPID,
NAME,
VALUE,
LMD
FROM
D:\Qlikview\excel\incri.xlsx
(ooxml, embedded labels, table is Sheet1)
Where LMD > '$(vvLMD)';
LET vNoOfNewRows = NoOfRows('Incr'); // Variable to hold count of new rows, use this variable wherever you required.
Concatenate
LOAD EMPID,
NAME,
VALUE,
LMD
FROM
D:\Qlikview\Practies\Incr.qvd
(qvd)
Where not Exists (EMPID,EMPID);
vvLMD=VLMD;
STORE Incr into Incr.qvd;
Regards,
Jagan.
I want to only newly added and changed records.
Hi Jangan,
Can you send me sample application, that would more help for me.
Advance Thanks,
Munna