How To Avoid multiple if conditions

Tue, 16 Dec 2014 06:50:12 GMT

How can I use 'Pick with match' functions for handling below multiple if conditions. I want to optimise below expression. Pls. help.

=if( DischargeDRG= '280' or DischargeDRG= '281' or DischargeDRG= '282' or DischargeDRG= '283' or DischargeDRG= '284' or DischargeDRG= '285','AMI'

,if(DischargeDRG= '216'or DischargeDRG='217'or DischargeDRG='218'or DischargeDRG='219'or DischargeDRG='220'or DischargeDRG='221'or DischargeDRG='231'or DischargeDRG='232'or DischargeDRG='233'or DischargeDRG='234'or DischargeDRG='235'or DischargeDRG='236', 'CABG or Valve'

,if(DischargeDRG= '246' or DischargeDRG= '247' or DischargeDRG= '248' or DischargeDRG= '249' or DischargeDRG= '250' or DischargeDRG= '251' or DischargeDRG= '286' or DischargeDRG= '287', 'Coronary Cath'

,if(DischargeDRG= '222' or DischargeDRG= '223' or DischargeDRG= '224' or DischargeDRG= '225' or DischargeDRG= '226' or DischargeDRG= '227' or DischargeDRG= '242' or DischargeDRG= '243' or DischargeDRG= '244' or DischargeDRG= '245' or DischargeDRG= '258' or DischargeDRG= '259' or DischargeDRG= '260' or DischargeDRG= '261' or DischargeDRG= '262' or DischargeDRG= '265','EP'

,if(DischargeDRG= '291' or DischargeDRG= '292' or DischargeDRG= '293','HF'

,if(DischargeDRG= '288' or DischargeDRG= '289' or DischargeDRG= '290' or DischargeDRG= '294' or DischargeDRG= '295' or DischargeDRG= '296' or DischargeDRG= '297' or DischargeDRG= '298' or DischargeDRG= '299' or DischargeDRG= '300' or DischargeDRG= '301' or DischargeDRG= '302' or DischargeDRG= '303' or DischargeDRG= '304' or DischargeDRG= '305' or DischargeDRG= '306' or DischargeDRG= '307' or DischargeDRG= '308' or DischargeDRG= '309' or DischargeDRG= '310' or DischargeDRG= '311' or DischargeDRG= '312' or DischargeDRG= '313' or DischargeDRG= '314' or DischargeDRG= '315' or DischargeDRG= '316','Other Medical'

,if(DischargeDRG= '228' or DischargeDRG= '229' or DischargeDRG= '230' or DischargeDRG= '237' or DischargeDRG= '238' or DischargeDRG= '239' or DischargeDRG= '240' or DischargeDRG= '241' or DischargeDRG= '252' or DischargeDRG= '253' or DischargeDRG= '254' or DischargeDRG= '255' or DischargeDRG= '256' or DischargeDRG= '257' or DischargeDRG= '263' or DischargeDRG= '264','Other Surgical'

,if(DischargeDRG= '1' or DischargeDRG= '2' or DischargeDRG= '001' or DischargeDRG= '002' or DischargeDRG= '215','VAD or Transplant',

'Non-Circulatory'

))))))))

Re: How To Avoid multiple if conditions

its_anandrjs — Tue, 16 Dec 2014 07:47:18 GMT

Hi Pankaj,

Use Mapping table for this and Map this table with the Fact table or transaction table where this if logic requires. By doing this your application having good performance in load perspective also. For mapping create another mapping table and load the data as mapping table or you can use Inline tables. I explain this in Inline table

Ex:-

DiscMap:

Mapping Load * Inline [

DischargeDRG,Desc

280,AMI

281,AMI

282,AMI

283,AMI

284,AMI

285,AMI

220,Valve

221,Valve ];

Fact:

Load

ApplyMap('DiscMap',DischargeDRG,'Non-Circulatory') as Details,

Fields,

....

From Source;

Regards

Anand

topic How To Avoid multiple if conditions in QlikView

How To Avoid multiple if conditions

Re: How To Avoid multiple if conditions