Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
sumitjadhav
Creator II
Creator II

how to add a new calculated dimension in a table?

how to add a new calculated dimension in a table box? is it possible,if possible then explain?

8 Replies
gautik92
Specialist III
Specialist III

you cannot add calculated dimension unless you have added in the script

sunny_talwar

Calculated dimension cannot be added to a table box object. You can add it to a straight table or pivot table object.

Not applicable

as per my understanding you cannot use Calculated dimension in Table box insted calculate that one at script level. like

LOAD

sum(Sales) as TotalSale,

From

and use TotalSale in Table box instead of Sales

avinashelite

No in Table box you cannot add the calculated dimension, except table box you can add in other objects.

Not applicable

Hi,

You can use only dimensions in Table Box,No Expressions and Calculated dimensions can be used.

Expressions and Calculated dimensions can be used in Pivot or Straight Table

Anonymous
Not applicable

Hi ,

If You want to display the Calculation .you have to do it at back end itself .and call that field in Table box.

Calculated dimensions and expressions cant be created.

or else

post your sample requirement .

thanks

bunny

NareshGuntur
Partner - Specialist
Partner - Specialist

What made you think of adding a calculated dimension in a table box rather than using a Straight table?

Anonymous
Not applicable

Hi Sumit,

You cannot use Calculated Dimension in Table box, but can be used in Straight/Pivot Table.

Table box is for only displaying Facts and Dimensions.