How to display value in list box even no association for that

[#1]

hi qlikers

i have  table

LOAD

  *,

  if(Late > 0 and Late <= 5,'<5 Min',

  if(Late > 5 and Late <=10 ,'5-10 Min',

  if(Late > 10 and Late <=15 ,'10-15 Min',

  if(Late > 15 and Late <=20 ,'15-20 Min',

  if(Late > 20 and Late <=30 ,'20-30 Min',

  if(Late > 30 ,'>30 Min')))))) as LateBy;

here there is no data for the <5 Min and 10-15 Min,

in list box it is showing

LateBy

5-10 Min

15-20 Min

20-30 Min

>30 Min

but i want list box like

LateBy

<5 Min

5-10 Min

10-15 Min

15-20 Min

20-30 Min

>30 Min

how to achieve this please help me

[sujeetsingh]

Use a Inline to create this field

Line Inline [

New Field

LateBy

<5 Min

5-10 Min

10-15 Min

15-20 Min

20-30 Min

>30 Min

]

Then you van use a trigger on select field to make selection in the field that is in the data model.

[swuehl · Accepted solution]

I don't think you need triggers here.

Just create the dimension using the INLINE LOAD:

LOAD * INLINE [

LateBy

<5 Min

5-10 Min

10-15 Min

15-20 Min

20-30 Min

>30 Min

];

This will link to the field created in your other LOAD by same field name.