topic Re: Table Box in QlikView

Table Box

MuraliPrasath — Wed, 07 Oct 2015 11:01:10 GMT

Hi,

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

Re: Table Box

Wed, 07 Oct 2015 11:04:08 GMT

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

Re: Table Box

qlikviewwizard — Wed, 07 Oct 2015 11:05:49 GMT

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

Re: Table Box

Wed, 07 Oct 2015 11:06:00 GMT

or Load only dat field and use the where clause

where Plant=600

Re: Table Box

SreeniJD — Wed, 07 Oct 2015 11:06:51 GMT

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

Re: Table Box

avinashelite — Wed, 07 Oct 2015 11:07:06 GMT

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)

Re: Table Box

MuraliPrasath — Wed, 07 Oct 2015 11:07:27 GMT

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

Re: Table Box

avinashelite — Wed, 07 Oct 2015 11:09:28 GMT

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

Re: Table Box

Wed, 07 Oct 2015 11:10:06 GMT

You load your table and keep only the plant field,

and use where clause

Plant6000:

Load

Plant

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

Where Plant = 6000 as Plant6000;

Re: Table Box

MuraliPrasath — Wed, 07 Oct 2015 11:28:29 GMT

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 .......

Re: Table Box

avinashelite — Wed, 07 Oct 2015 14:34:59 GMT

Hi Murali,

Want is the need of creating separate table of each of the values in plant? because say suppose you have around 10 values today and you will create 10 tables . If some more values get added what you will do again you need to create the new tables rite?

if you explain what is the business need, we can guide you in the right path

Re: Table Box

Wed, 07 Oct 2015 16:54:55 GMT

Hi All,

since you want to show only plant 6000 as a dimension,

use calculated dimension as

if(plant='6000',plant)

hope its work for you.

Re: Table Box

MarcoWedel — Wed, 07 Oct 2015 20:34:26 GMT

Hi,

if you want to go for "straight tables" (my guess, as you mixed it with the term "table box"), you could do so like:

I think a pivot table might be the better choice, though:

hope this helps

regards

Marco