How to list all 10 row of raw data on table 1 ?

[paulyeo11]

Hi All

My total noumber row of raw data is 10 row.

50010           STOCK                          A  1 1996 31/07/1996          0.000000       848828.63-               0.00  50010

50010           STOCK                          A  1 1996 31/07/1996          0.000000       139050.05-               0.00  50010

50010           STOCK                          A  1 1996 31/07/1996          0.000000            4.93                0.00  50010

50010           STOCK                          A  1 1996 31/07/1996          0.000000       848828.63                0.00  50010

50010           STOCK                          A  1 1996 31/07/1996          0.000000       987873.75                0.00  50010

50010           STOCK                          A  2 1996 30/08/1996          0.000000       261354.42-               0.00  50010

50010           STOCK                          A  2 1996 30/08/1996          0.000000       301747.61                0.00  50010

50010           STOCK                          A  2 1996 30/08/1996          0.000000       889219.76                0.00  50010

50010           STOCK                          A  2 1996 31/08/1996          0.000000       899219.76-               0.00  50010

50010           STOCK                          A  2 1996 31/08/1996          0.000000            2.06-               0.00  50010

Mt Table only show only 3 row , may i know how to list all 10 row ?

[Anonymous · Accepted solution]

Above data is Transactional Data, if you load this transactional data in any table you will get 10 rows only if you have 10 unique combination.

When you show Year wise, It will group your data which QV is doing

[t_chetirbok]

You have data only for this 3 rows of year

[paulyeo11]

Hi All

Thank for both reply.

my question is there any way i can force QV display 3 row of raw data ?

Paul

[maxgro]

Add an unique identifier to the GL_TABLE (in script you can use recno() rowno())

Add the un id to the chart as dimension

Hide the un id in presentation tab

[paulyeo11]

Hi Sir

you answer is almost correct and very close,

I try below but is wrong :-

AutoNumberHash128(@58:77T,'TDSS') recno() As Link_GL_Key,

Paul

[maxgro]

if you want to add an id to table AA, when you load AA

AA:

load

     .....

     .....

     recno() as id

     .....

from

[paulyeo11]

Thank you it work now