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: 
Anonymous
Not applicable

How to get revenue bracket for the matrix?

Hi All,

Please look at the attachment and I will make buckets like below

I am trying like below expression, but not working

If(RBYM_Revenue>0 and RBYM_Revenue>=50000,'0-50000',

   If(RBYM_Revenue>500000 and RBYM_Revenue>=1000000,'0-100000'))

  • add a filter box to select a revenue bracket for the matrix  (0-50,000, 50,000-100,000, 100,000- 500,000, 5000,000, 1m, 1m-5m,5m -10m, 10m-20m, 20m+)

Please help me

Thanks,

Manoj

1 Reply
balabhaskarqlik

May be this:

(0-50,000, 50,000-100,000, 100,000- 500,000, 5000,000, 1m, 1m-5m,5m -10m, 10m-20m, 20m+)

If(RBYM_Revenue > 0 and RBYM_Revenue <= 50,000,'0-50,000',

If(RBYM_Revenue > 50,000 and RBYM_Revenue <= 100,000,'50,000-100,000',

If(RBYM_Revenue > 100,000 and RBYM_Revenue <= 500,000,'100,000-500,000',

If(RBYM_Revenue <= 5000,000,'5000,000',

If(RBYM_Revenue <= 1,0000,000,'1M',

If(RBYM_Revenue > 1,0000,000 and RBYM_Revenue <= 5,0000,000,'1M-5M',

If(RBYM_Revenue > 5,0000,000 and RBYM_Revenue <= 10,0000,000,'5M-10M',

If(RBYM_Revenue > 10,0000,000 and RBYM_Revenue <= 20,0000,000,'10M-20M','20M+'))))))))