Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2010-03-04 04:47 AM

Sum Problem

Dear All,

I have an Ecel file which have some numeric value in text format . When I edit the cell and press enter it turns to numeric. When I reload this excel file without fixinig text formated to numeric values I couldn't make Sum. Is it possible to get sum without changing the cell format from the excel file.

I also have some field with percentage symbol. I also want to sum them. Please also help me about this. Are there any specific statement like trim.

Hope to hear you soon.

Best Regards,

1,064 Views
0 Likes
1 Reply
gajapathy74
Creator II
Creator II
‎2010-03-04 05:45 AM

Hi,

If i understand your requirement correctly, you can append Num method in load script while loading the data from excel file. Please refer QlikView Help document for formatting the number.

Hope this will help you.

Regards,

162 Views
0 Likes