topic Re: Reload on field selection in QlikView

Reload on field selection

Anonymous — Wed, 19 Dec 2012 21:41:54 GMT

Dear all,

I was wondering if it's possible to reload data after a selection on a list box. I've a list box with some Type Code. Choosing a value, I would activate the reload function. How can I do it ?

Help please

Thanks in advance for your help

Re: Reload on field selection

CELAMBARASAN — Wed, 19 Dec 2012 21:47:42 GMT

Use field event trigger on the field selection.

Which you can found in the Triggers tab of document properties.

Re: Reload on field selection

Anonymous — Wed, 19 Dec 2012 21:58:20 GMT

Hi,

I did it but nothing happens. I have choosen the field and selected reload data, saved and close the document.

Then I open again the document , but when I make a selection on my field the reload is missing..

Re: Reload on field selection

CELAMBARASAN — Wed, 19 Dec 2012 22:01:47 GMT

Use macro to do it.

Sub Reload

ActiveDocument.Reload

End Sub

I checked Reload didn't worked. I dono whether it is a restriction or bug.

Hope the macro helps

Re: Reload on field selection

Gysbert_Wassenaar — Thu, 20 Dec 2012 12:19:29 GMT

See here for a solution

Re: Reload on field selection

Anonymous — Tue, 25 Dec 2012 15:32:30 GMT

HI, Gysbert thanks very much.

Just another pleasure: I don't understand how does it work.

Let me understand when the full loading is active and when the partial reload.

(I understood that the last one is activated when you choose an item)

Could you spend please, some minutes to give me any further ?

Thanks in advance

Re: Reload on field selection

Gysbert_Wassenaar — Tue, 25 Dec 2012 15:48:39 GMT

The two buttons each have a different action assigned to them. One does a normal reload, the other does a partial reload. The customer table is always reloaded the Customerdetails is only reloaded with a partial reload because of the ONLY keyword. Otherwise it would reload on a normal reload too. The where clause for Customerdetails uses a variable to only load the records of the customers selected in the listbox.

Re: Reload on field selection

Anonymous — Tue, 01 Jan 2013 21:30:25 GMT

Thanks !!