topic Re: multibox object in QlikView

multibox object

santhosh_k_n — Fri, 11 Apr 2014 10:17:05 GMT

Hi all,

In the multi box object, when no value is selected i need to show 'Please select value' or '-select-'

Please guide me.

Re: multibox object

nizamsha — Fri, 11 Apr 2014 10:29:02 GMT

In caption u can write or u can use help text its in the bottom from that u can do but for help text u have to select

Re: multibox object

MK_QSL — Fri, 11 Apr 2014 10:35:43 GMT

Consider that you have below dimensions in your multi box

Brand

Customer

Right Click >> General Tab >> Title >> write below expression

=IF((GetSelectedCount(Brand)+GetSelectedCount(Customer))=0,'Select Any Value','')

Hope this helps....

Re: multibox object

Fri, 11 Apr 2014 10:36:38 GMT

In caption of multibox, you can write the expression including your all field names used in multibox like:

if(getselectedcount(Field1)=0 and getselectedcount(Field2)=0 and getselectedcount(Field3)=0,'Select Any Field','')

In this case it will display help symbol when no any field is selected and after clicking on help symbol it will display 'Select Any Field' message.

If you don't want to display it in caption then you can take seperate text box and write same expression in it.

Hope this will help u..!

Re: multibox object

Roop — Fri, 11 Apr 2014 10:45:02 GMT

in title box:

if(Len(DimA) + Len(DimB) = 0, 'Please select a value' , '')

for DimA and DimB fields in the multi-box

Re: multibox object

santhosh_k_n — Fri, 11 Apr 2014 12:00:05 GMT

Thanks all,

I dont want to display select your value in cation or help text as am not using the caption here.

The 'select' words should be beside the drop down arrow before selecting the value

Re: multibox object

rustyfishbones — Fri, 11 Apr 2014 12:06:58 GMT

Add a Label to the Field like this

Re: multibox object

rustyfishbones — Fri, 11 Apr 2014 12:10:25 GMT

Add this as the label expression

Re: multibox object

nizamsha — Fri, 11 Apr 2014 12:17:19 GMT

In Label u can add This one

=if(GetFieldSelections(Month),'Month','Select Value')

Re: multibox object

santhosh_k_n — Fri, 11 Apr 2014 12:28:39 GMT

Hi Alan,

I tried this, But i didnt work

Re: multibox object

nizamsha — Fri, 11 Apr 2014 12:40:27 GMT

Try this one it will work

In Label u can add This one

=if(GetFieldSelections(Month),'Month','Select Value')

Re: multibox object

Fri, 11 Apr 2014 12:41:13 GMT

You can try the below expression in label of each field like:

for 1st field:

if(GetSelectedCount(field1)=0 and GetSelectedCount([field2])=0 and GetSelectedCount(field3)=0,'Select field1,'field1');

for 2nd field:

if(GetSelectedCount(field1)=0 and GetSelectedCount([field2])=0 and GetSelectedCount(field3)=0,'Select field2,'field2');

Like this for all fields.

Re: multibox object

Fri, 11 Apr 2014 12:56:11 GMT

Hi try this

Label expressions for the fields in multibox

Upadte:

=If(GetSelectedCount(Client_Name)>0,'Client_Name','---Select Client_Name---')

=If(GetSelectedCount(Client_Name_Fix)>0,'Client_Name_Fix','---Select Client_Name_Fix---')

=If(GetSelectedCount(Reference_ID)>0,'Reference_ID','---Select Reference_ID---')

Hope this helps you..

Re: multibox object

santhosh_k_n — Mon, 14 Apr 2014 10:25:26 GMT

Hi all,

Thanks for the responce.

But my requirement is not to show the label as '-select-' but to show in the values place a select when no value is selected.

i tried 'if(gectselectioncount(field)>0,field,'select')' as calculated field, this worked good to show 'select' but unable to make selection.

Re: multibox object

Roop — Mon, 14 Apr 2014 10:36:58 GMT

If you want the lable to read 'Select' only use the same as the example that Ravi Kumar supplied but change the label for the Say Level field to :

='if(Len(Level) = 0, 'Select', 'Level') and this would show the label 'Level' only when a value has been selected.