topic Re: Re: replacing if statement with set analyisis in QlikView

replacing if statement with set analyisis

Wed, 21 May 2014 03:27:15 GMT

hi all,

Can anyone help me out to replace these following 'if' statements with set analysis method please.

if([Fee type] = 'Contract Price', sum({<[Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}>}[Nominal Quantity])*-1,[Nominal Quantity]*-1)

if([Buy/Sell]='BUY',(( sum({<[Buy/Sell]={'BUY'}, [Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}, Location -= {'MET COAL','API5'}>}[Nominal Quantity])/1000)*-1)+

( sum({<[Buy/Sell]={'BUY'}, [Base Index]={'FIXED CASH'}, [Fixed/Index Price]={'FIXED','INDEX'}, Location = {'MET COAL','API5'}>}[Nominal Quantity])/500)*-1)

Re: replacing if statement with set analyisis

Wed, 21 May 2014 05:50:48 GMT

can someone please help me out with this??

Re: replacing if statement with set analyisis

Wed, 21 May 2014 06:14:09 GMT

Hi Sahana,

Can u attach sample file so it would be simple for community to make changes and post back

Thanks,

Prakash

Re: Re: replacing if statement with set analyisis

Wed, 21 May 2014 06:31:12 GMT

Hi Prakash,

I have attached a test application with the same 2 exp A and B.Can you help me out now buy replacing this expression in set analysis to obtain the same result.