Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
christophd
New Contributor III

Loading specific data

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!

1 Solution

Accepted Solutions

Re: Loading specific data

[Text];

LOAD Kostenart,

            Sprache,

            Beschreibung

FROM

CSKU.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Exists (Kostenart)

and lower(Sprache)='de';

3 Replies

Re: Loading specific data

[Text];

LOAD Kostenart,

            Sprache,

            Beschreibung

FROM

CSKU.xlsx

(ooxml, embedded labels, table is Tabelle1)

Where Exists (Kostenart)

and lower(Sprache)='de';

Re: Loading specific data

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
New Contributor III

Re: Loading specific data

Thanks both!

I always tried

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

So the second "where" was wrong

Community Browser