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: 
saipriya
Contributor
Contributor

Expression

Hi,

I have two fields.

1.bussiness case

2.Total budget

Here I want to get business names which total budget is > $0.5M.

So please suggest the expression for this problem urgent

 

 

 

Labels (4)
2 Replies
Mark_Little
Luminary
Luminary

Try 

SUM({<Total budget={"=SUM(Total budget)>5000000"}>}Total budget)

also could probably use an if statement

saipriya
Contributor
Contributor
Author

Not working