Conditional Statements in Set Analysis

[#1]

Is it possible to have a conditional If statement in a Set Analysis Expression?

This is my set analysis,

sum({Revenue_Pro} Order__c.Total_Order_Amount2__c)

but I also need to say that if(probability>70 and <100,sum Total_order_Amount)

Thanx

[erichshiino]

Hi, Is probability a field?

If it is you can write something like:

sum( {<probability = {'>70<100'}>} Total_order_Amount)

Why do you have {Revenue_Pro} on your original set analysis?

--

Regards,

Erich

[#3]

Yes Probability is a field. The reason the previous set analysis had Rev_Pro is because I was originally going to use a bookmark, but it failed.

So is there a way to combine the

sum({ $<Order__c.AppforBooking_MonthYear={[05-2011]}>} Products_OTR__c.Total_Price__c) and

sum( {<probability = {'>70<100'}>} Total_order_Amount)

into a single state or do they need to be seperate?

[erichshiino]

if I understood you correctly, you can use it like this:

sum({ $<Order__c.AppforBooking_MonthYear={[05-2011] , probability={'>70<100'}}>} Products_OTR__c.Total_Price__c)

( did the answer at http://community.qlik.com/thread/28300 work for you?)

[#5]

There seems to be a syntax issue with the "=" after prbability....any idea what would cause that?

[erichshiino]

I've seen problems with the syntax checker on QV 10. Not sure if this is your case? Did it give you the right results?

[#7]

Unfortunately, due to the syntax, id returns nulls....

[erichshiino]

I wrote an extra }  at the end and remove one in the middle...

Please, try this one:

sum({ $<Order__c.AppforBooking_MonthYear={[05-2011]}, probability={'>70<100'}>} Products_OTR__c.Total_Price__c)

[#9]

Thanx for trying...same issue with the "=" sign. It's giving me a syntax error on the equals

[danielrozental]

I believe it should be

sum({ $<Order__c.AppforBooking_MonthYear={'05-2011'}, probability={">70<100"}>} Products_OTR__c.Total_Price__c)

Please disregard what the syntax checker might say, it doesn't always gets it right.