topic Re: How to stop straight table expression to load into excel? in QlikView

How to stop straight table expression to load into excel?

Wed, 22 Jul 2015 13:38:20 GMT

Hi,

I have dimensions and expression in straight table as below

Dim1: ID

Dim2: IF(Match(Store,'AA'),Store)

Dim3:ENTER

Dim4:LEAVE

Dim5:IF(Match(Region,'US'),DATE_IN_US)

Dim6:NAME

Expr: 1

when I am sending data to excel expression is loading into table as column. Is there any way to stop the expression to load into excel.

I know if I disable the expression all the straight will be disable.

Please can anyone suggest me is there any way to do this.

Thanks.

Re: How to stop straight table expression to load into excel?

sasiparupudi1 — Wed, 22 Jul 2015 13:47:02 GMT

add a lable to the dimension

HTH

Re: How to stop straight table expression to load into excel?

mjayachandran — Wed, 22 Jul 2015 13:53:01 GMT

! !If I understand correctly, You don't want to see the Expr: 1 which is your expression in Excel output..

Unfortunately its not possible to do it on a Pivot chart. However, my work around is as attached.

Re: How to stop straight table expression to load into excel?

Wed, 22 Jul 2015 13:53:11 GMT

Thanks. this will pull the column any way. I want completely the column not to load into excel. is there any way.

Re: How to stop straight table expression to load into excel?

Wed, 22 Jul 2015 14:11:31 GMT

Hi Amelia,

There is a workaround which you could do but doing this will hide the expression column in the screen and also in the Excel output.

As you are using a straight table, try doing the following:

Go to properties --> Select the 'Presentation' tab --> Select the expression field and select the option 'Hide Column'.

This will hide the column in the screen and also in the Excel output and will not disable the straight table.

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 10:35:51 GMT

there is only one column as expression as 1. remaining columns are dimensions. I have tried this if I hide expression it will completely hide the table.

is there any other solution? please suggest

Re: How to stop straight table expression to load into excel?

avinashelite — Thu, 30 Jul 2015 10:44:47 GMT

no the it should not hide the table completely , I think it has some other problem ..can you please share your app lets have a check

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 10:49:51 GMT

I've attached a simple example which shows the table is visible even when the expression is hidden. But if you can, try sharing a scaled down version of your application which might help to identify the cause of the problem.

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 12:20:04 GMT

so Sorry!! I uncheck the box under expression. yes it I not hiding completely.

how to hide if it is pivot table? Is there any option?

Re: How to stop straight table expression to load into excel?

avinashelite — Thu, 30 Jul 2015 12:22:28 GMT

go to expression :

On your expression their is conditional ...give false() here

and then go to presentation tab and un-check the suppress zero option

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 12:22:41 GMT

Thanks. this some how showing blank column. is there any way to hide the space?

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 12:26:51 GMT

Thanks that's working.

Re: How to stop straight table expression to load into excel?

avinashelite — Thu, 30 Jul 2015 12:39:27 GMT

cool !!! Explore QV

Re: How to stop straight table expression to load into excel?

Thu, 30 Jul 2015 12:47:20 GMT

Glad we could help