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

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
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 (2)
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.