topic Re: Calculated dimensions in script not loading in table box in QlikView

Calculated dimensions in script not loading in table box

Thu, 11 Dec 2014 13:39:30 GMT

Hi all,

I'm currently working on a piece and it requires a few calculated dimensions.

I've added them into my script

LOAD

Field1

Field2

Field3

Field4

Field5

//calculations

[Field1]/[field2] as [Calculated1],

[Field3]/[Field1] as [Calculated2],

([Field4]+[Field5])/[Field2] as [Calculated3]

FROM

aaa.xls

The issue I'm having is if I display them in my table box, the table becomes greyed out and has a big X in the middle. All other data is fine. I can do this in a straight table but I'm displaying a lot of dimensions so it doesn't look nice without the horizontal scrollbar.

Any suggestions on this?

Re: Calculated dimensions in script not loading in table box

Michiel_QV_Fan — Thu, 11 Dec 2014 13:42:46 GMT

You are adding to much data to the table box and it cannot display.

Try making selections first to limit the results in your table box.

What about a pivot table instead of a scrolling straight table?

Re: Calculated dimensions in script not loading in table box

Anonymous — Thu, 11 Dec 2014 13:43:20 GMT

Hello,

Can you send the sample app?

Serhan