topic Re: difference of QVD data in QlikView

difference of QVD data

sanjujeeboy — Fri, 15 Nov 2024 23:33:35 GMT

I have a qvd with current hour data:

hour sales

20 1000

i have another qvd with previous hour data

Hour sales

19 500

how can i do difference in qvds in back end to get output as

Hour Sales

1 500

Re: difference of QVD data

Chanty4u — Thu, 26 Nov 2020 04:09:03 GMT

Hi try this

a:
LOAD * , AutoNumber( hour & '|' & sales) AS UID
Inline [
hour , sales

20 , 1000

];
b:

LOAD * , AutoNumber( Hour & '|' & Sales) AS UID inline[
Hour ,Sales

19 , 500
];

EXIT SCRIPT;

Re: difference of QVD data

Reyyeess — Fri, 27 Nov 2020 04:31:47 GMT

Thanks for the update and quick reply. I'll be sure to keep an eye on this thread. Looking for the same issue. Bumped into your thread. Thanks for creating it. Looking forward for solution.