https://community.qlik.com/t5/QlikView/Search-in-script-in-previous-loaded-data-according-more/m-p/1559899#M744053 <P>Dear experts,</P><P>&nbsp;</P><P>I would like to ask you for support.</P><P>By loading data I would like to add column “Previous_Price” according 2 conditions (needs to match Product and time frame of Date).</P><P>“Previous_Price” shoud be: Find previous price for Product which is first in time-frame starting 365 days backward.</P><P>Expected result is distinguishable by colors.</P><P>Obstacle for me is to combine 2 conditions by searching the value in previous loaded data.</P><P>&nbsp;</P><P>Thank you very much in advance.</P><P>&nbsp;</P><P>Juraj</P> Sat, 16 Nov 2024 04:04:46 GMT Juraj_SK 2024-11-16T04:04:46Z https://community.qlik.com/t5/QlikView/Search-in-script-in-previous-loaded-data-according-more/m-p/1559899#M744053 <P>Dear experts,</P><P>&nbsp;</P><P>I would like to ask you for support.</P><P>By loading data I would like to add column “Previous_Price” according 2 conditions (needs to match Product and time frame of Date).</P><P>“Previous_Price” shoud be: Find previous price for Product which is first in time-frame starting 365 days backward.</P><P>Expected result is distinguishable by colors.</P><P>Obstacle for me is to combine 2 conditions by searching the value in previous loaded data.</P><P>&nbsp;</P><P>Thank you very much in advance.</P><P>&nbsp;</P><P>Juraj</P> Sat, 16 Nov 2024 04:04:46 GMT https://community.qlik.com/t5/QlikView/Search-in-script-in-previous-loaded-data-according-more/m-p/1559899#M744053 Juraj_SK 2024-11-16T04:04:46Z