Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Excel export in qlikview

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''

3 Replies
hemanthaanichet
Creator III
Creator III

Hi Deva,

Can u share screen shots r sample data

Regards

Hemanth

Not applicable
Author

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
Creator III
Creator III

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