How can list all records?

[#1]

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

[boorgura]

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.

[#3]

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

[boorgura]

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?

[johnw · Accepted solution]

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?

[#6]

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