Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Need to insert expression in Table box

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

Tags (1)
Labels (1)
9 Replies
cabhijit
Valued Contributor

Re: Need to insert expression in Table box

You cannot write expressions in  the TableBox

anbu1984
Honored Contributor III

Re: Need to insert expression in Table box

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

Not applicable

Re: Need to insert expression in Table box

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

MVP
MVP

Re: Need to insert expression in Table box

Hi

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

Not applicable

Re: Need to insert expression in Table box

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

Not applicable

Re: Need to insert expression in Table box

Check this qvw file

pradeepreddy
Valued Contributor II

Re: Need to insert expression in Table box

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

Hi,

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

use  Wrap cell/Header Text

Regards

Regards,
Prashant Sangle
Not applicable

Re: Need to insert expression in Table box

Thanks

it is not solving my problem

Community Browser