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: 
felcar2013
Partner - Creator III
Partner - Creator III

need dynamic index for current selected field value list

hi

how can i get a dynamic index field  that assigns the current selection a number in asc order?

like this:

load      A,

             B,

              rowno() as Index_Fix

from table.csv;

this would be the fix index. if i filter and get  a subset of rows, the index_fix will display numbers assigned to the corresponding field in the table. Assume i have Num Rows = 100. If i filter in my application, my current selection accounts for,say 23 rows. I want to create a dynamic index, which assigns to the current selection a number in numerical order: 1,2,3,4,5, ... 23.

If i do a second filter of fields and i get as current selection 4 rows, then my dynamic index shall assign to the rows 1,2,3,4

how would this be possible?

thanks for any help

Felipe

21 Replies
felcar2013
Partner - Creator III
Partner - Creator III
Author

i finally used the text box solution, showing comments as a list, including a line break between comments

thanks

felcar2013
Partner - Creator III
Partner - Creator III
Author


Hi swuehl,

do you know how to display 3 comments only, each time  the user clicks on an object (comments are in sequence)? and this by using the text boxes, with firstsortedvalue, as you proposed. This is, the user creates a filter, and reduces the amount of comments. Three text boxes must be displayed at once showing a comment each of them until the user click on an object (in form of navigation button) and the next three comments are then displayed in the same manner and so on.

is this possible?