Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kcville
Contributor II
Contributor II

Set Analysis to calculate Proportional Increase for positive values only

Hello

I have a Dimension 'Customer' and I would like to work out the proportion of increase from 2019 to 2020, only if they had a positive Sales.

Can anybody help me with the set analysis please to work out the Proportional Increase?

Kelly

 

Customer2019 to 2020 IncreaseProportional Increase
CustomerA-100 
CustomerB20050%
CustomerC20050%
   
Total 400100%

 

 

 

Labels (2)
1 Reply
H_Julian
Contributor III
Contributor III

Just Create another Dimension Field in the Script:

if(Value>=0,Value)) as PositiveValue

and write the SetExpression with this Field