Straight table problem with Copy to Clipboard/Cell Value

Sun, 18 Dec 2011 14:59:24 GMT

Hello,

I have a straight table with two dimensions, dim1 and dim2, and one expression meant as lineno, = RowNo(TOTAL)

Then I dragged the expression column to the first column in the table.

When I press the right mouse button on a cell value in the second column (dim1) and select 'Cell Value' via 'Copy to Clipboard' then I get the value from the first column (the expression).

When I do this in the third column then I get the value from the second column.

[data]:

LOAD * Inline [

Dim1, Dim2

aaa, AAA

bbb, BBB

ccc, CCC

ddd, DDD

]

;

Straight table

lineno Dim1 Dim2

------ ---- ----

1 aaa AAA

2 bbb BBB

3 ccc CCC

4 ddd DDD

What is the problem and is there another way to create a linenumber in the table by, for example, a calculated dimension ?

St0ny

Re: Straight table problem with Copy to Clipboard/Cell Value

Anonymous — Tue, 31 Jul 2012 01:44:06 GMT

I think this calcualated dimension should work:

aggr(Rowno(),Dim1)

Regards,

Michael

topic Straight table problem with Copy to Clipboard/Cell Value in QlikView

Straight table problem with Copy to Clipboard/Cell Value

Re: Straight table problem with Copy to Clipboard/Cell Value