topic Conditional Statements in Set Analysis in QlikView

Conditional Statements in Set Analysis

Wed, 18 May 2011 17:54:50 GMT

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

Conditional Statements in Set Analysis

erichshiino — Wed, 18 May 2011 18:36:30 GMT

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

Conditional Statements in Set Analysis

Wed, 18 May 2011 18:57:03 GMT

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?

Conditional Statements in Set Analysis

erichshiino — Wed, 18 May 2011 19:07:02 GMT

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?)

Conditional Statements in Set Analysis

Wed, 18 May 2011 19:17:29 GMT

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

Conditional Statements in Set Analysis

erichshiino — Wed, 18 May 2011 19:18:54 GMT

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?

Conditional Statements in Set Analysis

Wed, 18 May 2011 19:21:00 GMT

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

Conditional Statements in Set Analysis

erichshiino — Wed, 18 May 2011 19:27:42 GMT

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)

Conditional Statements in Set Analysis

Wed, 18 May 2011 19:30:59 GMT

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

Conditional Statements in Set Analysis

danielrozental — Wed, 18 May 2011 19:33:42 GMT

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.