topic Re: Excel export in qlikview in QlikView

Excel export in qlikview

Wed, 23 Nov 2016 06:35:18 GMT

Hi,

I need a column to be ''general'' while exporting to excel.

I have taken an empty column as ='' in dimension and it is working fine.

When i'm exporting to excel i'm getting column as text but i need it as ''general''

hemanthaanichet — Wed, 23 Nov 2016 06:39:15 GMT

Hi Deva,

Can u share screen shots r sample data

Regards

Hemanth

Wed, 23 Nov 2016 07:03:06 GMT

Hi,

When i'm exporting to excel i'm able to get all fields in general but i couldn't get ''Remarks'' field in general.

I'm getting it as text.

hemanthaanichet — Wed, 23 Nov 2016 07:34:47 GMT

Hi Deva,

I think your doubt is

All the column are exported with actual name but not remarks. i mean

Id as id

name as name

marks as marks

=' not as =' but as remarks

am i rite?

If yes here is the reply

As it is a calculated dimension and you label the column as remarks so while export it will show as u given

You can change label for other dimension and even expression too

I hope the below attachment will be helpful

Regards

Hemanth