Expression in straight table

[#1]

Hi,

I have a straight table with detail dimension.In detail chart,Parent_Num field should have different name based on the AD_ID dimension.

The requirement is

for AD_ID=5007,5001,5008,5007,5009 Parent_Num column in the "Detail record of A_Available" (Once you click on any AD_Desc, it ll populate detail straight table) should display as KEY_TER

for ID=5003,5004,5005,5006,5010,5011 it should display as Prnt_KEY.For rest others KEY_DTL..

I have tried with some expressions.But when there is two ID, it's not working correctly.

=if(AD_ID=1001 or AD_ID=1032,'KEYONE Count',if((AD_ID>=1005 and AD_ID<=1019) or (AD_ID>=1035 and AD_ID<=1050) ,'Prnt TER','KEY TER'))

Please note: In real scenarios the ID's will be more so please suggest simplified expression.I have tried with

nested IF statement but result already mentioned.

Steve Dark

Thanks in advance.

[swuehl]

Is this any different from http://community.qlik.com/thread/102180

If not, please try to avoid creating multiple posts for the same issue.