Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
AmCh
Creator
Creator

Import tables

Hi all,

I have the following table in xls. as an example:

0
0
5
5
3
2

Desired import as it is and not what the LOAD function does:

0
2
3
5

How can I avoid this?

Thanks in advance

Labels (1)
1 Solution

Accepted Solutions
QFabian
MVP
MVP

Hi @AmCh  @lironbaram  , additionally, this is a screenshot of how are fields and data shown :

 

QFabian_0-1610632691772.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

hi ,
when you drag the field to the screen it will only show distinct values 
but if you use a function like sum(yourField) you'll see 15

QFabian
MVP
MVP

Hi @AmCh  @lironbaram  , additionally, this is a screenshot of how are fields and data shown :

 

QFabian_0-1610632691772.png

 

Greetings!! Fabián Quezada (QFabian)
did it work for you? give like and mark the solution as accepted.