Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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?
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.
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
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?
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?
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