show same data

[#1]

I'm importing a file .csv in qlikview and I have a table like

0

0

0

0

but in the imported table it shows only ones. How can I let the program show all the data?

Thank you,

Giacomo

[CELAMBARASAN]

Hi,

     You mean you have single column which has only zeros and its is showing only one zero?

     Where you checked?

Celambarasan

[#3]

yes that is what I mean! Instead of an entire colum of zero I have only one!

[CELAMBARASAN]

Hi,

     Have you checked in the table view(Ctrl+T) or in list box?

Celambarasan

[#5]

no I did't checked.

I'm sorry, these are the first days I'm using qlikview, I have to learn from zero.

what does it mean?

Thanks,

J

[CELAMBARASAN]

Hi,

     List boxes shows only once.You can came to know the number of occurrences by checking Show Frequency option in the List box properties.

Celambarasan

[#7]

ok I understand,

but can I show all the zero in the column??

[CELAMBARASAN · Accepted solution]

Hi,

     Ya sure you can do that.

     Try with this

     Load * Inline[

     Field1,Field2

     1,0

     2,0

     3,0

     4,0

     5,0

     6,0];

Create table box with this 2 fields.

Celambarasan

[rbecher]

Hi Jack,

you have to add a key column (like a primary key, you could use the RecNo() function for this) because the table object (UI) will only display distinct rows (like in listbox).

- Ralf

[#10]

I am going t try it! thank you, I have to deal with tables with 10000 data or more.. I think it will take a little too much time in this way!

Do you know if in the list box there is a sort of distict or something like this?