Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
ahaahaaha
Partner - Master
Partner - Master

Hi Vani,

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

Regards,

Andrey

Anonymous
Not applicable
Author

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

devarasu07
Master II
Master II

Hi,

Can you share your sample app. Tks

Anonymous
Not applicable
Author

Hi Deavarasu

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

tripatirao
Creator II
Creator II

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

Anonymous
Not applicable
Author

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

tripatirao
Creator II
Creator II

Hi Vani,

The sum is showing.

Please check.

Anonymous
Not applicable
Author

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.

adamdavi3s
Master
Master

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