Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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?
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?)
There seems to be a syntax issue with the "=" after prbability....any idea what would cause that?
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?
Unfortunately, due to the syntax, id returns nulls....
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)
Thanx for trying...same issue with the "=" sign. It's giving me a syntax error on the equals
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.