topic Table box showing BIG X in QlikView

Table box showing BIG X

Mon, 24 Mar 2014 14:37:48 GMT

When I am trying to add a new filed in the exsiting table box.It is showing a BIG X on the table box .How i can fix it.

thanks in advance.

Re: Table box showing BIG X

its_anandrjs — Mon, 24 Mar 2014 14:44:52 GMT

Hi,

May be in your Data model has synthetic keys or may be some calculation going on when you add a field in table box. It will be due to some keys that will not proper or any field has a large data set thats why it is occur.

Check for any circular loop also in the data model.

Hope this helps

Thanks & Regards

Re: Table box showing BIG X

Mon, 24 Mar 2014 18:24:29 GMT

It is not like that.Actually even if I remove some existing field from table box and again try to add it.it again showing the same big X on table box.

Re: Table box showing BIG X

Mon, 24 Mar 2014 18:29:49 GMT

How many fields do you have. How big is the application. I bet its the size. Try adding fields one by one and at one point you will find out when this x appears. It means at that point the threshold is reached (you might be having a RAM constraint).

Try doing a limited load it should work fine. Whenever you are working on Desktop version its good to use limited data set (if you dont have enough RAM).

Re: Table box showing BIG X

its_anandrjs — Mon, 24 Mar 2014 18:45:35 GMT

Hi,

I suggest check your tables with dimension tables and fact tables might be some fields are in large data types as strings in character i mean to say. Also check there is any aggregation in the load script or not because of that when you add any field in the chart and when ram calculation occurs in the chart the ram overflows and the big X is shown. And check if any fields has large data width then use Trim(Fieldname) as newfieldname in load script to remove blank spaces from field and also check the data model performance is not slow when you add any field in the chart, also when you add any field and going to add second field in chart and if X comes check the field source and relation of the field among each other.

Hope this helps

Thanks & Regards

Re: Table box showing BIG X

Greg_Williams — Mon, 24 Mar 2014 19:23:09 GMT

This is typically caused from RAM overuse.

Considerations:

1. Reduce the # of fields in your table

2. Swap out dates for (year, month, day) fields

3. Add Error message handling logic to avoid this X, e.g. if a field to filter down on is not selected, it will state, please select an item from the listbox to reduce the # of fields to display in the table

4. Remove set analysis or calculated fields in the table (move to the script)

There are other techniques, but these are some to focus on at first.

Re: Table box showing BIG X

Tue, 25 Mar 2014 03:14:29 GMT

It is not like that.as even when I remove an existing field from table box and try to add that field again in table.box it shows same big X.

Re: Table box showing BIG X

Anonymous — Tue, 25 Mar 2014 03:30:07 GMT

Can you post a sample app, so that we can look over it and prove you soln in a better way.

Re: Table box showing BIG X

Tue, 25 Mar 2014 05:13:53 GMT

This is caused when fields used in Table Box are connecting to each other from multiple nodes at Data Model level(OverNormalized Data Model).

Are all the fields used in Table Box are coming from same QV Table? If not, try keeping only those fields which are from same table and see if it give a cross sign again or not.

Thanks,

Angad

Re: Table box showing BIG X

Tue, 25 Mar 2014 08:09:02 GMT

I am just using a single table.As mentioned when I remove one field from the table box and trying to again add field it shows big X on table box.

but when I add a totally new table box with all fields ,there is no problem.But adding a new table box caused a lot of rework for me.

I cant post a sample as it is my office work and it is for that particular situation.

Re: Table box showing BIG X

Tue, 25 Mar 2014 08:12:20 GMT

As it is a table box so there is no dimension and calculation.

Re: Table box showing BIG X

Greg_Williams — Tue, 25 Mar 2014 14:37:05 GMT

Did you copy the object from an existing object or did you build this from scratch? If not, try building the new object from scratch. Reminder - Table box for non-calculated fields and Straight Table has calculated fields.

Re: Table box showing BIG X

Wed, 26 Mar 2014 05:06:11 GMT

I think the table box which is showing X, must have already consumed much of RAM.

Can you right click anywhere on Sheet, to open the Sheet Properties and then navigate yourself to "Object" tab and see the "CalcTime" for that table box object. I believe it should be a large value.

Thanks,

Angad

Re: Table box showing BIG X

Wed, 26 Mar 2014 13:21:54 GMT

But even if I removed the existing field and try to add again that field .It again showing BIG 'X'.

Re: Table box showing BIG X

Greg_Williams — Wed, 26 Mar 2014 23:56:18 GMT

How much RAM is the object consuming? In Document Preferences > Memory Statistics? How much RAM does your machine have installed? Have you closed out of all other applications? Do you have any other tables or many other objects on your sheet? Are you able to remove some objects (especially hidden) to free up memory?

Re: Table box showing BIG X

Thu, 27 Mar 2014 06:01:19 GMT

So mean, that one field is causing this to happen? what is this field storing in it? Is it date, numeric or string values?

If its numeric, can you use num() in the script itself.

Can you share us with sample app...so that we can reproduce this as well?

Thanks,

Angad

Re: Table box showing BIG X

Thu, 27 Mar 2014 06:04:16 GMT

it is not that field dependent.Even if i remove any field from table box and try to add it again.It causes problem.

Re: Table box showing BIG X

Thu, 27 Mar 2014 06:06:19 GMT

Ok, can you try removing all fields..and just keeping one field(any). and then check does it still cause the problem.

If not, then one by one add fields into the table box.

Re: Table box showing BIG X

Thu, 27 Mar 2014 06:14:13 GMT

ok,I have removed all the fields except one.Then try to add one more field but again it showing the same problem.I think it is a bug of Table box.

Re: Table box showing BIG X

Thu, 27 Mar 2014 06:21:09 GMT

Seems like....But since you said, when you created a new table box it worked fine.

So I still believe, the particular object (table box) might have got corrupted.

Can you give another try, and change the ObjectID for that table box and see if it works. (It is a guess though)

Thanks,

Angad