Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
AlfredH
Contributor
Contributor

diff in period

What command I have to use in column Diff%?

Periode amount diff%
1 100  
2 90 90,0%
3 110 122,2%
4 120 109,1%
5 130 108,3%
6 100 76,9%
7 110 110,0%
8 115 104,5%
9 90 78,3%
10 20 22,2%
11 50 250,0%
12 100 200,0%
Labels (2)
2 Replies
mato32188
Specialist
Specialist

Hi @AlfredH ,

if you are using straight table or pivot chart, try to use sum(amount)/above(sum(amount)).

BR

m

ECG line chart is the most important visualization in your life.
AlfredH
Contributor
Contributor
Author

Nice and simple commando.

Thanks