topic Show all values in QlikView

Show all values

Wed, 29 Sep 2010 14:34:50 GMT

Hi,

I have a excel sheet with the following data.

CID Date Fact

1 22/06/2010 1

If I create Table dashboard its showing only 1 record like this (elimanating the duplicate records).

CID Date Fact

1 22/06/2010 1

If I want to get 2 records in the table dashboard where is the option to select show duplicate values.

Thanks,

Show all values

jonathandienst — Wed, 29 Sep 2010 14:39:47 GMT

Add RowNo() to the load to disambiguate the two rows like this:


LOAD
 CID,
 Date,
 Fact,
 RowNo() AS RowID
FROM DataSource;

Now include RowID in your table (you can hide that column)

Jonathan

Show all values

Wed, 29 Sep 2010 14:50:39 GMT

Thanks, but in table box dashboard we don't have hiding option.

Any best suggestion FYI..I am using 8.2 version.

Thanks,

Show all values

Wed, 29 Sep 2010 15:03:30 GMT

Hi there,

you can set the column to minimum size. You can also rename it with an space and make the font transparent or white.

Regards

Show all values

jonathandienst — Wed, 29 Sep 2010 15:07:52 GMT

You could also use a straight table chart. Use all 4 fields as dimensions and an expression =1 as the expression. Then hide the RowID and expression columns.

Jonathan

Show all values

Wed, 29 Sep 2010 15:24:21 GMT

Actually I am using 8.2 version, so in straight table we don't have hiding option.

Thanks,

Show all values

pover — Wed, 29 Sep 2010 15:31:49 GMT

Would it be reasonable to make the column as narrow as possible and change the text color to white so that you see any value?

I don't remember that hiding a column as somehting new between versions. To hide a column in a table you have to go to the Presentation tab below the list of columns. The hide option is not in the expressions tab like it is for other types of graphs.

Regards.

Show all values

Thu, 30 Sep 2010 04:12:32 GMT

I feel that we need to think in some technical way.

Thanks,