topic Qlikview removing data in SELECT statement in QlikView

Qlikview removing data in SELECT statement

Tue, 31 Mar 2015 08:27:20 GMT

I have a problem with loading data from one of our databases.

I have a table that contains the following values:

ITEM BATCH

1090 15 17 80

1090 151780

1090 197815

When I load the data into qlikview like this:

ItemBatches_temp:

SELECT

ITEM,

BATCH

FROM

ITBATABLE;

...I end up with a table containing only this:

ITEM BATCH

1090 151780

1090 197815

This is a problem since "15 17 80" and "151780" are both unique batches which need to be tracked. I need all the values, but I don't know how to get them both. Anyone run into this before?

When I extract data outside of qlikview with the same SQL it returns with all the batches.

Re: Qlikview removing data in SELECT statement

Anonymous — Tue, 31 Mar 2015 08:42:23 GMT

Try forcing BATCH to be loaded as text and not as numeric, maybe something like this :

ItemBatches_temp:

load

ITEM,

text(BATCH) as BATCH

;

SELECT

ITEM,

BATCH

FROM

ITBATABLE;

Re: Qlikview removing data in SELECT statement

Tue, 31 Mar 2015 08:54:43 GMT

Thanks! That was the ticket!

Re: Qlikview removing data in SELECT statement

jagan — Tue, 31 Mar 2015 08:59:49 GMT

Hi,

Try like this using Text()

ItemBatches_temp:

LOAD

ITEM,

Text(BATCH) AS BATCH;

SELECT

ITEM,

BATCH

FROM

ITBATABLE;

Hope this helps you.

Regards,

Jagan.