topic Re: Import tables in QlikView

Import tables

AmCh — Sat, 16 Nov 2024 17:36:54 GMT

Hi all,

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

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

How can I avoid this?

Thanks in advance

lironbaram — Thu, 14 Jan 2021 11:36:57 GMT

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 — Thu, 14 Jan 2021 13:59:38 GMT

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