Hide a value for field in a multi box

[#1]

Hi,

I have a multi box with field [Record Type] with values as below. I would like to hide the value 'Replace and RT' , so that it doesn't appear in the drop down for the users to select. Also, If I select type 'Replace', its should trigger the selection of 'Route' and 'Replace and RT'or selecting route triggers selection of 'Replace' and ' Replace and RT'.

Record type
New
Replace and RT
Replace
Route
Cancel
Order

Thanks in Advance.

[#2]

I already have a table that holds the information for all record types. but when i select the record type'Replace or Route'  it should display the information as shown above. I have other columns too but record type with id is always unique.

[Simon_J · Accepted solution]

Hi Mohan,

In that case, could you add an expression in the multibox with:

=if(RecordType = 'Replace and RT',  'Replace', RecordType)

This will then allow you to have a selection in the multibox where you can select Replace and it will select Replace and Replace & RT in the table

[#4]

Hi Simon,

Thanks for your response. Its working fine.

[vishsaggi]

Sorry for late reply. I am not sure how we can achieve selecting Replace and Route to get all the values of Replace+Route+Replace and RT.

Extending Simon Johnson script:

Update your Multibox expression with this:

= IF(Match(Recordtype, 'Replace and RT'),'Replace',

  IF(Match(Recordtype, 'Replace and RT'), 'Route',

  IF(Match(Recordtype, 'Route'), 'Replace',

  IF(Match(Recordtype, 'Replace'), 'Route',

   Recordtype))

))

But here you have to select Replace and Route together to get all values displayed in the table.

It doesn't match your requirement but just a thought if that works for you.

[#6]

Hi Vish,

I have got it working. thanks, I appreciate your time

[Anonymous]

Hi Mohan,

We're glad to see you were able to solve your issue. Please take a moment to Mark Replies as Correct or Helpful to give points to those who helped and to mark the thread as Answered.

Regards,

Qlik Community Team

[vishsaggi]

Oh good to hear that. Was that a different solution to the ones mentioned above ? If yes can you share with us your resolution and how you achieved ?

[#9]

It was the same solution as above..