topic show same data in QlikView

show same data

Thu, 01 Mar 2012 08:53:52 GMT

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

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

Thank you,

Giacomo

show same data

CELAMBARASAN — Thu, 01 Mar 2012 08:58:03 GMT

Hi,

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

Where you checked?

Celambarasan

show same data

Thu, 01 Mar 2012 09:04:39 GMT

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

show same data

CELAMBARASAN — Thu, 01 Mar 2012 09:05:57 GMT

Hi,

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

Celambarasan

show same data

Thu, 01 Mar 2012 09:09:08 GMT

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,

show same data

CELAMBARASAN — Thu, 01 Mar 2012 09:09:09 GMT

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

show same data

Thu, 01 Mar 2012 09:32:07 GMT

ok I understand,

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

show same data

CELAMBARASAN — Thu, 01 Mar 2012 09:36:14 GMT

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

show same data

rbecher — Thu, 01 Mar 2012 09:40:19 GMT

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

show same data

Thu, 01 Mar 2012 09:41:07 GMT

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?

show same data

CELAMBARASAN — Thu, 01 Mar 2012 09:42:34 GMT

Hi,

List box always shows distinct values only.

Celambarasan