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

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

suvechha_b — Fri, 18 Dec 2015 09:55:44 GMT

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 — Fri, 18 Dec 2015 10:01:29 GMT

hi,

hope this helps u

Chanty4u — Fri, 18 Dec 2015 10:02:51 GMT

it may be..

settu_periasamy — Fri, 18 Dec 2015 10:08:04 GMT

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'))