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

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
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''

Labels (1)
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