Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Thanks in advance.
Is this any different from http://community.qlik.com/thread/102180
If not, please try to avoid creating multiple posts for the same issue.