Price Change%

[v_jaideep]

Hello Experts,

I need to calculated Price Change % and Total Price Change % based on Name .I tried using previous(), aggr() but couldn't find workaround. Any help pls.

Below is the sample data . 

Name	Launch Date	Start Date	End Date	Price	Price Change %	Total Price Change%	(Calculation)reference
A	2-Nov-19	2-Nov-19	3-Mar-20	$   100.00
A	2-Nov-19	4-Mar-20	8-Sep-20	$     70.00	$              (0.30)		(70-100)/100
A	2-Nov-19	9-Sep-20		$     60.00	$              (0.40)	$                        (0.40)	(60-100)/100
B	25-Mar-18	25-Mar-18	18-Oct-19	$   120.00
B	25-Mar-18	19-Oct-19	2-Nov-19	$   110.00	$              (0.08)		(110-120)/120
B	25-Mar-18	3-Nov-19	3-Mar-20	$     80.00	$              (0.33)		(80-120)/120
B	25-Mar-18	4-Mar-20		$     230.00	$              0.92	$                        0.92	(230-120)/120

[rubenmarin · Accepted solution]

Hi, you can try with Top(): (Price-Top(Price))/Top(Price)

[v_jaideep]

Rubenmarin, Thanks for the response. But I have my requirement change. 😞

Can you please help on below post

https://community.qlik.com/t5/Qlik-Sense-App-Development/Current-Price-vs-Launch-Price/m-p/1795016/h...

[rubenmarin]

I see Rob has already answered, hope that helps, otherwise I didn't understand the bold launch prices, they are the same value as the price column.

[v_jaideep]

I tried few possibilities using Intervalmatch() to get launch_price and current_price in same row for each product. Below is the table structure I have and expected data.

Table A:
Start_date,
End_date,
Local_Price,

currency,
key

Table B:
Launch_date,
product,country,area,region,province,size,unit

name,
key

Expected data in table should be as below:

Product     Current_Price    Launch_Price

AB               3788                         4450

AC               12.52                       18.52

AD                100                                90