topic Set Analysis Help in QlikView

Set Analysis Help

abhaysingh — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Set Analysis Help

susovan — Tue, 12 Jul 2016 11:55:24 GMT

Hi abhay,

Try this expression,

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

Re: Set Analysis Help

abhaysingh — Tue, 12 Jul 2016 12:02:57 GMT

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

Re: Set Analysis Help

qlikview979 — Tue, 12 Jul 2016 12:12:17 GMT

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

Re: Set Analysis Help

maniram23 — Tue, 12 Jul 2016 12:16:13 GMT

Hi,

Try This Expression,

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

Regards

Re: Set Analysis Help

kkkumar82 — Tue, 12 Jul 2016 12:20:32 GMT

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.