topic Re: Data Export to Excel from QlikView in QlikView

Data Export to Excel from QlikView

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Data Export to Excel from QlikView

ahaahaaha — Mon, 06 Mar 2017 11:17:31 GMT

Hi Vani,

Check that that the uploaded data in Excel have a number format.

Regards,

Andrey

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 07:34:23 GMT

Hi Andrey

I am getting values correctly, but the problem is that Excel is displaying like some condition has been applied to that cell

Re: Data Export to Excel from QlikView

devarasu07 — Fri, 10 Mar 2017 08:30:16 GMT

Hi,

Can you share your sample app. Tks

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 09:28:20 GMT

Hi Deavarasu

Attached exported file,problem is in Excel only as all values are coming correctly from QlikView

Re: Data Export to Excel from QlikView

tripatirao — Fri, 10 Mar 2017 09:41:05 GMT

Hi,

Look at the attahced file

Here one yellow colour button is there. There click on convert to number.

After that try to sum.

Regards

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 09:52:38 GMT

Hi Tripati

I am not getting values when I have currency symbol infront of number,if I remove it and apply the thing you have said values are coming perfectly

Re: Data Export to Excel from QlikView

tripatirao — Fri, 10 Mar 2017 10:00:38 GMT

Hi Vani,

The sum is showing.

Please check.

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 10:31:37 GMT

I haven't understood how you are doing it.Can you explain?As I am not getting yellow color box for whole column as you.

Re: Data Export to Excel from QlikView

adamdavi3s — Fri, 10 Mar 2017 10:41:30 GMT

Please see the attached where I have added two different options and explained my workings so you can see how it is done

Re: Data Export to Excel from QlikView

annafuksa1 — Fri, 10 Mar 2017 10:42:18 GMT

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

Re: Data Export to Excel from QlikView

annafuksa1 — Fri, 10 Mar 2017 10:44:51 GMT

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

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

Re: Data Export to Excel from QlikView

dsharmaqv — Fri, 10 Mar 2017 10:47:45 GMT

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

either money or integer

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 11:06:08 GMT

Hi Adam

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

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 11:07:11 GMT

Hi Anna

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

Re: Data Export to Excel from QlikView

adamdavi3s — Fri, 10 Mar 2017 11:24:46 GMT

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

Re: Data Export to Excel from QlikView

Anonymous — Fri, 10 Mar 2017 11:44:09 GMT

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.

Re: Data Export to Excel from QlikView

adamdavi3s — Fri, 10 Mar 2017 11:49:06 GMT

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?

Re: Data Export to Excel from QlikView

dsharmaqv — Fri, 10 Mar 2017 11:49:19 GMT

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

Re: Data Export to Excel from QlikView

annafuksa1 — Fri, 10 Mar 2017 12:08:50 GMT

could you post your app with sample of data ?