topic save selection into variable in QlikView

save selection into variable

Fri, 13 Nov 2009 14:10:22 GMT

How do i save the selection of a table into a variable?

Mon, 16 Nov 2009 13:49:52 GMT

Hi elint10110

You can do this By using Micro

for example ,if you have MyVar defined variable and you want to store last current selected value in this variable then

Sub

CurrentSelection

set

X=ActiveDocument.GetCurrentSelections

S=X.selections

V=X.VarId

For

i=lbound(S) to ubound(S)

ActiveDocument.Variables(

"MyVar").SetContent S(i), true

End

Sub

By using this micro you will get current selected value in the variable MyVar

And other related information please go through API topics(Get Selected Values and Variables )

Hope this will help you

Anonymous — Fri, 17 Feb 2012 14:55:41 GMT

That micro, where should be located??? in the script editor?

Anonymous — Fri, 17 Feb 2012 15:00:04 GMT

Create one variable in your dashboard and assign the following function in the variable

Your variable = =GetCurrentSelections()

Regards

Ashok

Anonymous — Fri, 17 Feb 2012 15:00:59 GMT

Please remove on assignment operater '=' from previous post

Regards

Anonymous — Fri, 17 Feb 2012 15:03:13 GMT

Using the

Variable name =GetFieldSelections(YourFieldName) you can specifically stored particular field selected value in the variable

Regards