Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Data Export to Excel from QlikView

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?

24 Replies
Master
Master

Re: Data Export to Excel from QlikView

Hi Vani,

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

Regards,

Andrey

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi Andrey

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

excel.PNG

Highlighted
Master II
Master II

Re: Data Export to Excel from QlikView

Hi,

Can you share your sample app. Tks

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi Deavarasu

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

Highlighted
Creator II
Creator II

Re: Data Export to Excel from QlikView

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

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

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

Highlighted
Creator II
Creator II

Re: Data Export to Excel from QlikView

Hi Vani,

The sum is showing.

Please check.

Highlighted
Creator
Creator

Re: Data Export to Excel from QlikView

Hi

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.

Highlighted
Master
Master

Re: Data Export to Excel from QlikView

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