topic Set Analysis Formula Help in QlikView

Set Analysis Formula Help

Fri, 20 May 2011 11:43:54 GMT

I am trying to get the below formula to provide me a 90 day forecast/summation on Total order Amount.

sum({($_3 $<Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)

Unfortunately it returns a null set. Please Help.

Thanx

Set Analysis Formula Help

erichshiino — Fri, 20 May 2011 11:55:48 GMT

Hi,

The error can be at any point...

but when you use the $_3 you shouldn't use it with the $. It must be one or the other.

sum({($_3 <Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)

sum({($_3<Order__c.AppforBooking_MonthYear={[05-2011]}>} Order__c.Total_Order_Amount2__c)

The $_3 means the third next selection. It means that the user had done many selections, moved back (using the back button) three times and you want to go back to that first selection before back buttons. If the user didn't move back, $_3 wil return a null set of records.

Hope it helps,

Erich

(Did the answers at others posts work for you?)

Set Analysis Formula Help

Fri, 20 May 2011 12:58:35 GMT

Erich

Thank you for all of the advice...unfortunately the answers to previous posts didn't work, but I appreciate all of your information

Allen