Set Analysis Help

[abhaysingh]

hi all,

i have one condition which i want to write in set analysis and to avoid if condition

condition is:

if( Customer = NA and Production not equal to PD and GL not equal to 123 ,

     if( customer = REPL, AVG(rate))

pls suggest. how i can put it in set analysis

[susovan]

Hi abhay,

Try this expression,

Avg({<Customer={'NA'},Production-={'PD'},GL-={'123'}>}rate)

[abhaysingh]

if(CUSTOMER_NO= 'NA' and PRODUCT_GROUP<> 'PRICE-DIFFERENCE' and [G/L_Account_No] ='0000703401' or [G/L_Account_No] ='0000703405' or [G/L_Account_No] ='0000703403' or [G/L_Account_No] ='00007034011' or [G/L_Account_No] ='0000703412' or [G/L_Account_No] ='0000703201',

avg({<[G/L to Consider], CUSTOMER_NO = {'000000REPL'} >}FINAL_CONSOLIDATED_BGT_RATE1))

this i want to do in set analysis..

Hi Mr ghosh, let me simplify more

if( Customer = NA and Production not equal to PD and GL not equal to 123  than

     if( customer = REPL, AVG(rate))

in your case Customer NA  value will come and in my case it is blank ...i want to fill it will customer REPL value

thanks for support

[qlikview979]

Hi Try this

May be help ful to you

Alt(Avg({<CUSTOMER-={'NA'},PRODUCTION-={'PD'},GL-={'123'}>}RATE))

Alt(Avg({<CUSTOMER={'NA'},PRODUCTION-={'PD'},GL-={'123'}>}RATE))

Expression updated

[maniram23]

Hi,

Try This Expression,

avg({<CUSTOMER_NO= {'*REPL'} ,PRODUCT_GROUP-={'PRICE-DIFFERENCE'} ,[G/L_Account_No] -={'*123'}>}FINAL_CONSOLIDATED_BGT_RATE1))

Regards

[kkkumar82]

Hi Abhay,

Not Sure about set analysis but you can try this in the function as

avg(if( Customer = 'NA' and Production <> 'PD' and GL <> 123, if( Customer = 'REPL', rate)))

Just one doubt, How a customer value can be NA and REPL both at a time.