topic Re: Hide a value for field in a multi box in QlikView

Hide a value for field in a multi box

Wed, 25 Nov 2020 16:16:04 GMT

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.

Re: Hide a value for field in a multi box

Simon_J — Thu, 11 Aug 2016 15:14:11 GMT

Hi Mohan,

Can you not edit this in your load script so you have :

If([Record Type] = 'Replace and RT', 'Replace', [Record Type] ) as [Amended Record Type]

This way you have an amended field ready to use from your dataload. You could then do an OR clause to include the Route fields as well so that Replace, Replace and RT and Route are classified as the same thing

Is that what you are after?

Simon

Re: Hide a value for field in a multi box

sunny_talwar — Thu, 11 Aug 2016 15:18:43 GMT

Try like this:

Aggr(Only({1<[Record type] -= {'Replace and RT'}>} [Record type]), [Record type])

If([Record type] <> 'Replace and RT', [Record type])

Ignore my response, and use the above response.

Re: Hide a value for field in a multi box

Thu, 11 Aug 2016 15:27:13 GMT

Hi Simon,

thanks for your response. I can not modify it on the load script because I have a few other tables which will be affected..So I want to restrict it on the front end, if at all possible..

Re: Hide a value for field in a multi box

vishsaggi — Thu, 11 Aug 2016 15:36:06 GMT

Did not quite understand your second requirement, but to hide values in Multibox, just use this expression:

= IF(RecordType = 'Replace and RT', NULL(), RecordType)

Re: Hide a value for field in a multi box

Thu, 11 Aug 2016 15:47:06 GMT

Hi Vish,

It is not working...my record type 'Replace and RT' still shows up in the drop down. Thanks for ur time

Re: Hide a value for field in a multi box

vishsaggi — Thu, 11 Aug 2016 16:03:54 GMT

Strange it works for me.

Add recordtype into Multibox -> Click edit and type the expression and label the expression.

Re: Hide a value for field in a multi box

Thu, 11 Aug 2016 16:27:42 GMT

Vish,

Thanks its working now.. I messed up something.

Re: Hide a value for field in a multi box

Thu, 11 Aug 2016 16:52:21 GMT

The second part is that, If I select record type either " Replace" or "Route" in the filter, I should get all the information related to Route and Replace and RT (So all the records with Record type: Replace + Route + Replace and RT). Example as below:

Record Type	ID
Replace	abc1
Route	abc1
Route	xyz 1
Replace and RT	abc123

Thanks in Advance.

Re: Hide a value for field in a multi box

vishsaggi — Thu, 11 Aug 2016 18:08:18 GMT

Is this the table you want to display when you select the filter ? Are there only two fields or you have any additional information or data. ?

Re: Hide a value for field in a multi box

Thu, 11 Aug 2016 18:13:17 GMT

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.

Re: Hide a value for field in a multi box

Simon_J — Fri, 12 Aug 2016 12:20:45 GMT

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

Re: Hide a value for field in a multi box

Fri, 12 Aug 2016 14:10:02 GMT

Hi Simon,

Thanks for your response. Its working fine.

Re: Hide a value for field in a multi box

vishsaggi — Fri, 12 Aug 2016 15:11:36 GMT

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.

Re: Hide a value for field in a multi box

Fri, 12 Aug 2016 16:25:43 GMT

Hi Vish,

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

Re: Hide a value for field in a multi box

Anonymous — Fri, 12 Aug 2016 16:30:48 GMT

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

Re: Hide a value for field in a multi box

vishsaggi — Fri, 12 Aug 2016 16:33:14 GMT

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 ?

Re: Hide a value for field in a multi box

Fri, 12 Aug 2016 17:03:54 GMT

It was the same solution as above..