Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Straight table problem with Copy to Clipboard/Cell Value

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

1 Reply
Anonymous
Not applicable
Author

I think this calcualated dimension should work:

aggr(Rowno(),Dim1)

Regards,

Michael