Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
srikanth1994
Contributor
Contributor

Chart expression

Hi Qlik Learners,

I am new to Qlik please can anyone tell me the expression for below logic

CM% >63% and recurring revenue >98k = High value customers

Labels (5)
3 Replies
Mohan_hitman
Contributor III
Contributor III

if({{'98'}>}High value customers)
srikanth1994
Contributor
Contributor
Author

Hi

I want like this if both conditions satisfy then show as High value customers

if CM% is >63% and recurring revenue>98k then show as High value customers

BrunPierre
Master
Master

Aggregationfunction({< CM%={">96"}, [recurring revenue]={">98000"}>}Measure)