Table Box

[MuraliPrasath]

Hi,

I need to show my Plant straight table box dimention as default value as 6000. how to do that?

[#2]

Hi,

U want to restrict the plant value to 600

use this

in the script you extract the data ie plant having 600 and give a name for it and use that field in the table box

[qlikviewwizard]

What does the mean of default? Can you elaborate your requirement.

[#4]

or Load only dat field and use the where clause

where Plant=600

[SreeniJD]

if(isnull(Plant),6000) is that what you are looking?

[avinashelite]

if you want the entire to filter on Plant 6000 then use triggers> go to document properties> triggers> on Open > add action>select in field> Plant and value 6000

if you want only in the chart , you can add a calculated dimension like

if(getcurrentselection()=0,if(Plant='6000',Plant),Plant)

[MuraliPrasath]

I am not getting you. I need to show only Plant field 6000 value in the table.

[avinashelite]

see in the table box you do not have the option to write any conditions, you need to create a separate field in the script and then use the same in the table box

[#9]

You load your table and keep only the plant field,

and use where clause

Plant6000:

Load

Plant

From .......................

Where Plant = 6000 as Plant6000;

[MuraliPrasath]

Hi Avinash,

Still no luck, I need to show only Plant 6000 in the table.

like this I've to create tables for each Plant 6001,6002,6003 .......