Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

% of growth for each district in a straight table

I want to create a straight table using the below columns

District ID

% of growth

expecting straight table

District ID
% of growth








----------------------------------------------------------------

my table

CustomerID
DistrictID
% of growth
115.2
214.1
322.2
4285.2
5147.2
6341.02

In each district there are many customers, so how can i get the growth % for each district in straight table?

4 Replies
Gysbert_Wassenaar

No idea. Average them perhaps? You'll have to explain how the growth percentages should be aggregated from customer-district level to district level. A growth percentage is usually based on two values. If you have these values you could aggregate those separately using the sum function and then calculate the growth percentage from those sums. That would give you a correct result. Using only the growth percentages that's impossible.


talk is cheap, supply exceeds demand
Not applicable
Author

I have columns Current_Year_Amount and Previous_Year_Amount to calculate growth percentages. could you please tell me how to get the result as you said in your reply?

Gysbert_Wassenaar

Use District as dimension and as expression sum(Current_Year_Amount)/sum(Previous_Year_Amount) -1. Change the Number format of the expression to Fixed, choose the number of decimals and enable the Percentage option.


talk is cheap, supply exceeds demand
Not applicable
Author

Thanks Gysbert.