topic Can we use calculated dimension in table box in QlikView

Can we use calculated dimension in table box

Tue, 08 Jul 2014 14:06:16 GMT

Can we use a calculated dimension in table box?

Re: Can we use calculated dimension in table box

maxgro — Tue, 08 Jul 2014 14:11:32 GMT

in table box you can only add fields

Re: Can we use calculated dimension in table box

sasikanth — Tue, 08 Jul 2014 14:25:50 GMT

NO you cannot use Calculated dim,

insted calculate that one at script level

LOAD

sum(sales) as SALE,,

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

......................

and SALE in Table box..

it may help

Re: Can we use calculated dimension in table box

Anonymous — Fri, 23 Mar 2018 14:19:53 GMT

Hello,

You can do that with a straight table (chart) that has dimensions but no expressions. Just make sure that "suppress zero-values" is unchecked in the Presentation tab. This will be like a table box, in that it will show all of the unique combinations of the dimensions you choose as they exist in your data model, but it will give you the functionality of a straight table.