Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have created a list box with the expression :
if(SERVICE_TIER = 'type1','type1',
IF(SERVICE_TIER = 'type2','type2',
IF(SERVICE_TIER = 'type3','type3','Internal')))
The list box shows up correctly in the development server. But on accesspoint it just shows up as internal (*4times) instead of the {type1,type2,type3,internal}
How to fix this?
I'm surprised it works in the development server... Based on my understanding, it shouldn't...
Try this:
=AGGR(
if(SERVICE_TIER = 'type1','type1',
IF(SERVICE_TIER = 'type2','type2',
IF(SERVICE_TIER = 'type3','type3','Internal')))
, SERVICE_TIER)
cheers,
Oleg Troyansky
Come and learn Set Analysis and Advanced Aggregation with me at www.masterssummit.com - take your QlikView skills to the next level!
I would recommend moving this logic to the script as create field/attribute with the same logic then use that field in the list box. It will provide more consistent results and also be useful in set analysis.
load
...
if(SERVICE_TIER = 'type1','type1',
IF(SERVICE_TIER = 'type2','type2',
IF(SERVICE_TIER = 'type3','type3','Internal'))) as Service_Tier_Type
from...
Thanks for your response.
I created a LOAD table with the SERVICE_TIER field and map Field , and used apply map in the table .It seemed to have fixed the problem.