topic Re: Straight Table is removing Repeated Entries in QlikView

Straight Table is removing Repeated Entries

Anonymous — Fri, 10 Apr 2015 15:11:40 GMT

I am importing the below data to QlikView from Excel file.

Column A	Column B
A	APPLE
A	APPLE
A	APPLE
B	DATES
C	GRAPES
D	Greece
E	MANGO
F	MELON
G	POME
H	ROME

When I create a straight table object QlikView is removing the repeated entries by collating it as a 1 entry and the result is below. Why QlikView is doing this? Is there a way to create a straight table without collating the repeated entry...(A APPLE)???

Column A	Column B

A	APPLE
B	DATES
C	GRAPES
D	Greece
E	MANGO
F	MELON
G	POME
H	ROME

Re: Straight Table is removing Repeated Entries

jpenuliar — Fri, 10 Apr 2015 15:17:05 GMT

Had a similar situation before;

Table box Rows does not match Charts/expressions/statistics aggregates

Re: Straight Table is removing Repeated Entries

jpenuliar — Fri, 10 Apr 2015 15:18:08 GMT

you can add a RecNo() in your Load script

e.g.

Load

RecNo,

[Column A],

[Column B]

...

Re: Straight Table is removing Repeated Entries

awhitfield — Fri, 10 Apr 2015 15:21:11 GMT

Qlikview will interpret the 3 Apples as three of the same item, if you added the expression (Count(ColumnA), yu would see this. See the example attached

Andy

Re: Straight Table is removing Repeated Entries

jpenuliar — Fri, 10 Apr 2015 15:22:56 GMT

Hey Bats!

Re: Straight Table is removing Repeated Entries

awhitfield — Fri, 10 Apr 2015 15:24:01 GMT

We strike again!

Re: Straight Table is removing Repeated Entries

jpenuliar — Fri, 10 Apr 2015 15:25:04 GMT

This Community more fun with 2 Bats

Re: Straight Table is removing Repeated Entries

vvvvvvizard — Fri, 10 Apr 2015 15:28:59 GMT

ctr+e , insert

after the load

rowno() as row_num,

field a , ....

Re: Straight Table is removing Repeated Entries

Anonymous — Fri, 10 Apr 2015 16:09:04 GMT

Thanks Yusuf. It worked.

Thanks everyone for the timely help.

Re: Straight Table is removing Repeated Entries

Anonymous — Tue, 14 Apr 2015 11:28:34 GMT

Guys need a help. I tried inserting RowNo() after Load statement and it worked great. But this time I am not having Load statement.. I am using SELECT directly... How should I include RowNo() now???