How to make the default value in multi box as Processed :

[suvechha_b]

1. How to make the default value in multi box as Processed :

see eg,

2. How can I put the chart value as 'Processed' and 'Unprocessed'.

eg, when category of sales selected as ' Processed ' , then the chart should show 'Processed Aspen Daily Sales Report' in upper case

and when category of sales selected as ' Unprocessed ' , then the chart should show 'Unprocessed Aspen Daily Sales Report' in upper case

[Chanty4u]

hi,

https://community.qlik.com/message/881281#881281

hope this helps u

[Chanty4u]

it may be..

Always one selected value in a expression based multibox

[settu_periasamy · Accepted solution]

Hi,

Try this,

1. Select the Processed in the Category Field  and in the Multibox Properties -> Presentation Tab -> Always One Selected Value

       (May be You can try to use the Trigger When file Open)

2.  Put the below expression in the Chart Properties -> General -> Window Title

If ([Category of Sales] = 'Processed', Upper('Processed Aspen Daily Sales Report'),

      If([Category of Sales] = 'Unprocessed',Upper('Unprocessed Aspen Daily Sales Report'))