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

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
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