Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

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

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 ?

1 Solution

Accepted Solutions
balrajahlawat
Esteemed Contributor

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

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

7 Replies
balrajahlawat
Esteemed Contributor

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

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
Valued Contributor

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

You have data only for this 3 rows of year

paulyeo11
Valued Contributor II

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

Hi All

Thank for both reply.

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

Paul

MVP
MVP

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

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
Valued Contributor II

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

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

MVP
MVP

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

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

AA:

load

     .....

     .....

     recno() as id

     .....

from

    

paulyeo11
Valued Contributor II

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

Thank you it work now

Community Browser