About duplicate values

[#1]

Hi,

I have an excel file contain values are,

1

1

1

2

2

3

4

5

5

6

6

but when i load this into list box it shows

1

2

3

4

5

6

and i need all values what should i do to get all values in excel as it is...

[marcus_sommer]

A listbox and also the table-boxes and table-charts won't display duplicate values by design. But the values aren't lost - if count over your field you will get the correct results.

If you want to show a tablebox which showed all records you need to add a unique record-identifier to the box which you could create within the script by using:

rowno() as RowNo

or

recno() as RecNo

- Marcus

[kaushiknsolanki]

Dear Gopi,

In Visualization, QlikView will always show you distinct value, but in backend the values are always same as what you have loaded.

To make sure that you have the same numbers of record, you can go to Settings-> Document Properties -> Table -> Here you will see the numbers of records loaded.

Regards,

Kaushik Solanki

[#4]

Yeah marcus thanx now i got it. But im facing other problem can i post it again for your ref...

[marcus_sommer]

Please create a new question if you have a new challenge.

- Marcus

[#6]

Here the first is DB value and second is QV values. The value 9431.30 should be shown twice in QV what to do for getting values...

[marcus_sommer]

If you had applied the unique record-identifier like mentioned above and those record is really missing then there will be only one possiblity left and this is the use of a distinct-statement within your load-script. Please notice that a distinct-statement worked also on tables which are merged per join or concatenate from other tables.

If this solved your case please check the data within your database if they are really like you expect them and that the colored row in your screenshot isn't a TOTAL-row.

- Marcus

[MindaugasBacius]

Just create the Table object. I guess the table contains more values that aren't the same. You'll get the whole table.

In case the rows are identical through out all the fields then in the backend script create field rowno(). After reloading the data again create the Table object and you'll see all the values.

[ramasaisaksoft]

Hi Gopi,

You can't show all values in List box ,but you have an option how many times it is repeated.

List box->General Properties->After your selected field (Right hand side )you can find an check box

Show Frequency may be it will help to you.

[beck_bakytbek]

Hi Prakash,

if you want to see all values, i can use in such cases this function:

if (aggr(NODISTINCT Count(yourField1), yourField2, yourField1)>1,1,0

with this function you can see your duplicates / your all values

hope that helps

beck