topic Re: Loading specific data in QlikView

Loading specific data

christophd — Tue, 01 Dec 2015 07:29:58 GMT

Hi all,

in our Company we started with Qlikview now and the only help is a book for developers

So hopefully you can help me a little bit...

I have a main data and want to load a second table now, but not the whole table.

My Syntax:

[Text];
LOAD Kostenart,
Sprache,
Beschreibung

FROM
CSKU.xlsx
(ooxml, embedded labels, table is Tabelle1)
Where Exists (Kostenart);

It is a table with translations for a lot of languages.

Is it possible to load only the data, where "Sprache" is filled with "DE"?

Thanks a lot!

Kushal_Chawda — Tue, 01 Dec 2015 09:21:24 GMT

[Text];

LOAD Kostenart,

Sprache,

Beschreibung

FROM

CSKU.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Exists (Kostenart)

and lower(Sprache)='de';

tamilarasu — Tue, 01 Dec 2015 09:22:43 GMT

Hi Christoph,

What you mean by second table.? Something like below!!!

[Text];

LOAD Kostenart,

Sprache,

Beschreibung

FROM

CSKU.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Sprache= 'DE';

christophd — Tue, 01 Dec 2015 09:49:24 GMT

Thanks both!

I always tried

...Where Exists (Kostenart)and where (Sprache)='DE';

So the second "where" was wrong