topic How can list all records? in QlikView

How can list all records?

Fri, 14 May 2010 19:06:01 GMT

Hi,

I'm new of QlikView. So my question may seem easy for someone.

I have a table

Product value

A 10

A 20

B 15

I would like a report within all my records (3) like database table without sum.

How can I do it?

Thanks a lot

Regards

Marilena

How can list all records?

boorgura — Fri, 14 May 2010 19:19:05 GMT

You can use a table box.

or if you need a chart (pivot table or straight table), use Product as a dimension and Value as Expression.

How can list all records?

Fri, 14 May 2010 19:34:02 GMT

Thanks, I have tried but the results were

Table box

A 10

B 15

And it doesn't show A - 20

Pivot

A 20

And the others?

Perhaps I have set some attributes or I have to set something.

Regards

Marilena

How can list all records?

boorgura — Fri, 14 May 2010 19:56:44 GMT

I used a table box for just 3 values:

And i can display the values as:

A 20

A 10

B 15

not sure, what the problem on your end is?

How can list all records?

johnw — Fri, 14 May 2010 20:25:48 GMT

A table box will combine rows if every field has the same value. But the Value field is different, so they shouldn't be combined. If you want to make certain QlikView doesn't combine any rows, you'll need to assign every row a unique ID, such as with recno(). Then add the unique ID to the table box. That will prevent anything from rolling up. It doesn't appear to be your exact problem, but it's relevant for this sort of problem.

Your actual results appear nonsensical to me. Perhaps post an example application with the problem?

How can list all records?

Fri, 21 May 2010 13:01:41 GMT

Thanks a lot for your suggestion

I have created a unique key in the data base too in order to have two different records.

Now it run right.

Ciao

Marilena