Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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