topic Re: Need to insert expression in Table box in QlikView

Need to insert expression in Table box

Mon, 26 Jan 2026 18:19:17 GMT

Hello All

i need to add 4 expression values in table box

is it possible

i want to create volume1 and volume2

with expression

i am having 53 columns in straight table it is going

u can see the scroll bar it is going to fare

Re: Need to insert expression in Table box

AbhijitBansode — Fri, 13 Feb 2015 05:34:45 GMT

You cannot write expressions in the TableBox

Re: Need to insert expression in Table box

anbu1984 — Fri, 13 Feb 2015 05:34:58 GMT

If you want to display data as is, then use Table box. You cannot have expressions in Table box.

Use Chart to display dimensions and expressions

Re: Need to insert expression in Table box

Fri, 13 Feb 2015 05:40:13 GMT

in above screen i had showed that is stright table only it is going out of screen

i can't drag to fit in screen

Re: Need to insert expression in Table box

jonathandienst — Fri, 13 Feb 2015 05:54:37 GMT

I understand the problem you are having with a straight table. You cannot use a table box, as it does not support expressions. What a about using a pivot table? Check the option "Always Fully Expanded". This will scroll more conveniently than a straight table.

In a pivot, you can make the left most fields narrower, as they can wrap to multiple lines. You could also experiment with Indent mode in the Style tab of the properties dialog as another way to make your table more compact.

HTH

Jonathan

Re: Need to insert expression in Table box

Fri, 13 Feb 2015 06:06:15 GMT

Thanks jonathan

my problem is with straight table or pivot table it is going out of screen i want to scroll to extream right to export to excel in qvw itself.

imagine at access point level to is to accord

i want to reduce it size

in table box i can reduce the size but i can't write expression.

In straight table or pivot table scroll bar problem

Re: Need to insert expression in Table box

Fri, 13 Feb 2015 06:22:29 GMT

Check this qvw file

Re: Need to insert expression in Table box

PradeepReddy — Fri, 13 Feb 2015 06:29:39 GMT

if you want to export the the table data, no need to go extream right and click on the excel icon.

Just right click anywhere on the chart and select "Export to Excel" option.

For scroll bar issue, try adhoc reporting style. So that you can select the desired fields from the list box selections.

Thanks,

Pradeep

Re: Need to insert expression in Table box

PrashantSangle — Fri, 13 Feb 2015 06:36:02 GMT

Hi,

Reduced Column Size and in Presentation tab use Multiline setting to show complete data

use Wrap cell/Header Text

Regards

Re: Need to insert expression in Table box

Fri, 13 Feb 2015 06:45:50 GMT

Thanks

it is not solving my problem