Expression Doubt

rohitians — Mon, 29 Apr 2013 08:14:39 GMT

Hello,

IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 OR GLAcc_Code = 31027506) AND (Div_Code>2010 AND Div_Code<2999),'Regulated Market'
,IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 OR GLAcc_Code = 31027506) AND (Div_Code>3000 AND Div_Code<3999),'Semi Regulated Market'
,IF((GLAcc_Code=31011002 OR GLAcc_Code=31026999),'API Domestics'
,IF((GLAcc_Code=31027502 OR GLAcc_Code=31027505),'API Exports',
))))

Here i have calculated dimension as above but i want to introduce total of regulated and semi regulated in this as well and API DOM and API Exports as well..

I am attaching the excel file for better understanding,

Thanks and Regards,

Rohit

Re: Expression Doubt

m_woolf — Mon, 29 Apr 2013 20:46:12 GMT

I suggest that you load this logic in your script something like this:

IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504 ORGLAcc_Code = 31027506) AND (Div_Code>2010 AND Div_Code<2999),'Regulated Market'
,IF((GLAcc_Code=31027501 OR GLAcc_Code=31027503 OR GLAcc_Code = 31027504OR GLAcc_Code = 31027506) AND (Div_Code>3000 AND Div_Code<3999),'Semi Regulated Market'
,IF((GLAcc_Code=31011002 OR GLAcc_Code=31026999),'API Domestics'
,IF((GLAcc_Code=31027502 OR GLAcc_Code=31027505),'API Exports',
)))) as NewField;

topic Re: Expression Doubt in QlikView

Expression Doubt

Re: Expression Doubt