Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Juraj_SK
New Contributor

Search in script in previous loaded data according more conditions.

Dear experts,

 

I would like to ask you for support.

By loading data I would like to add column “Previous_Price” according 2 conditions (needs to match Product and time frame of Date).

“Previous_Price” shoud be: Find previous price for Product which is first in time-frame starting 365 days backward.

Expected result is distinguishable by colors.

Obstacle for me is to combine 2 conditions by searching the value in previous loaded data.

 

Thank you very much in advance.

 

Juraj

Labels (3)