Maximum Percent Change in a Year based on conditions in SET Analysis

[AnmolUdhlani]

Hi Guys! 

I just started using Qlik sense and now pretty much stuck while using SET analysis. Would really appreciate the help from our community. Here is the format of Data I have:

Manufacturer	Brand	Year	Values
A	A1	2018	5
A	A2	2018	7
A	A3	2018	8
A	A1	2017	6
A	A2	2017	8
A	A3	2017	10
B	B1	2018	4
B	B2	2018	2
B	B3	2018	4
B	B1	2017	5
B	B2	2017	2
B	B3	2017	6

I want to create a table using a chart object in which the first column is "Manufacturer" and the second column is the "Max % change for any product by that Manufacturer"

Here is the final output that  I need:

Manufacturer	Max % Chng
A	25%
B	50%

That is 25% in A3 by Manufacturer A, and 50% in B3 for manufacturer B.

Looking for some advice. 

[TimvB]

Hi, can you please explain how you calculate the "Max % change" - how did you find the values 25% and 50%? How would you calculate this in Excel? I do not understand the measure..

[AnmolUdhlani]

Hi Tim, thanks for your reply.

Here in my example, For example:

If for the manufacturer A, the % change in value from 2019 to 2020 is 10% for Product A1, 20% for Product A2 and 25% for Product A3. I want 25% to show up besides  'A' and same goes for Manufacturer B. The % change  in value of a product which is maximum should show up in the second column besides the column for the Manufacturer.

Can we do this through the Script Editor if not through the chart expressions?

Appreciate your help!

[TimvB]

Hi, I think this is double in the front-end by using the aggr() function. It is certainly possible in the script editor. However, I first need to fully understand your exact needs, and unfortunatly, I still do not get it... You provided example data of 2017 and 2018 but your example in the previous comment is from 2019 and 2020. Please provide an example calculation/description including numbers so that I can relate them. After that I can provide and expression or script.