Data Export to Excel from QlikView

[Anonymous]

Hi All

I have created a dashboard in QlikView and exporting it to Excel Sheet.Later if I try to do Sum in Excel by applying some condition,it is returning 0.But for some other sheets, it is returning values correctly.Can anyone please help?

[annafuksa1]

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

[annafuksa1]

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

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

[dsharmaqv]

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

either money or integer

[Anonymous]

Hi Adam

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

[Anonymous]

Hi Anna

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

[adamdavi3s]

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

[Anonymous]

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.

[adamdavi3s]

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?

[dsharmaqv]

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

[annafuksa1]

could you post your app with sample of data ?