topic Re: Compare Previous and Current row in QlikView

Compare Previous and Current row

rupaliqlik — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to calculate a flag where previous row and current row is same then give 'matched' else 'unmatched' in qlikview back end script.So when I select Flag as Matched I will get only those material no whose sales are matched .

Material	Report	Sales_New
000002FS	Qlikview	3510
000002FS	Shad	3640
4A3055	Qlikview	1275
4A3055	Shad	1275
9094200	Qlikview	11352
9094200	Shad	11352

Re: Compare Previous and Current row

Michiel_QV_Fan — Thu, 01 Nov 2018 15:01:12 GMT

Make sure your data is sorted right. Then use previous function (all in the script)

If(previous(Sales_new) = Sales_new, 'Matched', 'Unmatched') as Flag

Re: Compare Previous and Current row

Mark_Little — Thu, 01 Nov 2018 15:22:52 GMT

Hi,

You will need to look at PEEK() or PREVIOUS() functions

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Peek.htm

https://help.qlik.com/en-US/sense/September2018/Subsystems/Hub/Content/Sense_Hub/Scripting/InterRecordFunctions/Previous.

Mark

Re: Compare Previous and Current row

Anil_Babu_Samineni — Fri, 02 Nov 2018 03:34:51 GMT

Is that value you need by Material?

Re: Compare Previous and Current row

jyothish8807 — Fri, 02 Nov 2018 06:51:02 GMT

Try like this:

Load

Material,

Report,

Sales_New,

if(previous(Material)=Material and previous(Sales_New)=Sales_New, 'Matched', 'Unmatched') as Flag

from <>

order by Material;

Br,