Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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
sorry to '$#,##0.00;-$#,##0.00'
num(YourField,'$#,##0.00;-$#,##0.00')
Define field format in your app itself ....It will work
either money or integer
Hi Adam
I have many currency formats to do like what you have mentioned
Hi Anna
I have given the same number format in my expression and also selected Expression default in Number tab in 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
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.
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?
can you please explain what is your requirement and desired output. If you dont want to use format then you will face problem.
could you post your app with sample of data ?