Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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!
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.