Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
The #1 reason QlikView customers adopt Qlik Sense is a desire for a modern BI experience. Read More
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

Re: Data Export to Excel from QlikView

try to change the formating to '#,##0.00;-$#,##0.00'

num(YourField,'#,##0.00;-$#,##0.00') you export looks like is not formatted in Qlikview correctly

Highlighted
Creator III
Creator III

Re: Data Export to Excel from QlikView

sorry to '$#,##0.00;-$#,##0.00'

num(YourField,'$#,##0.00;-$#,##0.00')

Highlighted
Creator III
Creator III

Re: Data Export to Excel from QlikView

Define field format in your app itself ....It will work

either money or integer

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi Adam

I have many currency formats to do like what you have mentioned

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi Anna

I have given the same number format in my expression and also selected Expression default in Number tab in QlikView

Highlighted
Master
Master

Re: Data Export to Excel from QlikView

I've tested this and can't recreate the issue, but you might want to do as dsharmaqv‌ says and wrap your formula in a money() formula.

The only field I couldn't get to export properly is when the field is text within qlikview, i.e. the actual data field is £123

However once I wrap this in a money() it exports fine.

Please see the attached

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi Adam

What you have mentioned is correct,I am having actual data field as $123, but I am unable to wrap it in money format as I need to express it in many currency formats instead I am using Expression default in QlikView.

Highlighted
Master
Master

Re: Data Export to Excel from QlikView

hmmm, could you possible explain how the data looks?

I mean I am guessing from what you say you have data like

$123,

£123,

etc?

Highlighted
Creator III
Creator III

Re: Data Export to Excel from QlikView

can you please explain what is your requirement and desired output. If you dont want to use format then you will face problem.

Highlighted
Creator III
Creator III

Re: Data Export to Excel from QlikView

could you post your app with sample of data ?