Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
TG
Contributor
Contributor

Funktion RowNo() als Variable

Hallo,

ich benötige die Funktion RowNo() als variable, aber ich bekomme es irgendwie nicht hin.

In der Pivottabelle zeigt er mir keinen Wert an sofern ich es als variable benutze.


BG

Thorben

Labels (1)
1 Reply
EmmaMcAlister
Luminary
Luminary

Hi Thorben,

Are you using the dollar sign expansion, $(), to return the value of the variable in the table?
e.g. =$(vRowNo)

where vRowNo=RowNo()

Although this will return the same row number value (likely 1) for each row of the table as storing it as a variable will hold it as the single definition you have defined.

What are you trying to achieve with this being stored as a variable? If you want to display the row number in the pivot table you can use RowNo() directly as a measure. If you want to return the row numbers as they are in the original data set you could look at creating a RowNo field in your load script.