Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Had a similar situation before;
Table box Rows does not match Charts/expressions/statistics aggregates
you can add a RecNo() in your Load script
e.g.
Load
RecNo,
[Column A],
[Column B]
...
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
Hey Bats!
We strike again!
This Community more fun with 2 Bats
ctr+e , insert
after the load
rowno() as row_num,
field a , ....
Thanks Yusuf. It worked.
Thanks everyone for the timely help.
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???