topic Re: Price Change% in App Development

Price Change%

v_jaideep — Fri, 26 Mar 2021 09:59:14 GMT

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

Re: Price Change%

rubenmarin — Sat, 27 Mar 2021 08:47:34 GMT

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

Re: Price Change%

v_jaideep — Sat, 27 Mar 2021 09:58:14 GMT

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/highlight/true#M62311

Re: Price Change%

rubenmarin — Sat, 27 Mar 2021 19:23:32 GMT

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.

Re: Price Change%

v_jaideep — Mon, 29 Mar 2021 08:12:51 GMT

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