Expression in straight table

Wed, 18 Dec 2013 20:21:12 GMT

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.

Re: Expression in straight table

swuehl — Wed, 18 Dec 2013 20:39:50 GMT

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

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

topic Expression in straight table in QlikView

Expression in straight table

Re: Expression in straight table