topic Re: Move to certain value in table in QlikView

Move to certain value in table

john9inno — Fri, 08 May 2015 00:51:42 GMT

Hi all,

I am so curious about the possibility of solving this issue i have.

I have a straight table (or can be switched to Pivot, if needed) with aobut 200~400 rows in it.

my client has a request with that table.

he wants to find one certain value in that table but whole table needs to be retained.

e.g. in below table he wants to move to one single row with item name XYZ that may located in Row no 260.

however, whole table needs to be maintained. it is pretty much like 'Find' function in excel or web browser.

no change or particular selection in contents but need to find certain value in it.

Row No	Item	Value
1	XXa	A
2	XTb	B
3	AXc	C
	....	.....
399	AId	ZZ1
400	AWe	ZZ2

can you please get me any idea for me?

Re: Move to certain value in table

danieloberbilli — Fri, 08 May 2015 01:30:51 GMT

I think its not possible to move to a certain position.

Maybe as a alternative: you could use an input text field, write the search string in a variable and highlight the row according to the search:

Re: Move to certain value in table

maksim_senin — Fri, 08 May 2015 02:46:27 GMT

Hi,

I'm not sure (since didn't see that) if this is possible to access QV object from expressions so you'll hardly implement the requirement.

What can be done in order to show the value being looked for is a sorting expression. You can try implementing an expression which would move up the corresponding row to the very top of the table so the row becomes the 1st one.

Best regards,

Maxim

Re: Move to certain value in table

ToniKautto — Fri, 08 May 2015 03:49:50 GMT

There is no native function in QlikView that will allow to control the scroll position like your requirement.

Typically you explore your data in QlikView, so that your selections lead you towards conclusions and discoveries in the data. A alternative solution would then be that the table shortens based on selections and then you can highlight a specific row by color as suggested by Daniel.

The only way I can imagine to accomplish the requirement is to have a document extension that can adapt the table's scroll position. In this context it will require a custom solution, where the browser client HTML and JavaScript is used to alter the presentation. The base requirement is then that you can control the scroll through a JavaScript.

Re: Move to certain value in table

john9inno — Mon, 11 May 2015 00:27:08 GMT

Thank so much for your help.

I just have funny feeling that this is very possible with existing functions in QV.

the matter is how to combine them to make it work.

thanks again.